-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathAdvance_salaey.sql
More file actions
50 lines (47 loc) · 2.88 KB
/
Advance_salaey.sql
File metadata and controls
50 lines (47 loc) · 2.88 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
select info.CARDNO, info.JOINING_DATE ,info.ENMNAME_BANGLA, info.DESIGNATION_BANGLA,
info.DEPT_BANGLA, info.SEC_BANGLA,INFO.COMPANY, info.FATHER_NAME_BAN, loan.LOAN_AMT
from TB_ADVANCEORLOAN_MASTER loan, tb_personal_info info
where loan.company = :p_company
and info.company = loan.company
and loan.LOANYEAR = :p_year
and loan.LOANMONTH = :p_month
and loan.LOANDATE = :p_loan_date
and loan.LOAN_TYPE = 'Advance'
and info.CARDNO = loan.CARDNO
AND loan.REASON_STATUS LIKE DECODE(NVL(:p_status,'all'),'all','%',:p_status)
AND info.DEPARTMENTNM LIKE DECODE(NVL(:p_deptname,'all'),'all','%',:p_deptname)
AND info.SECTIONNM LIKE DECODE(NVL(:p_section,'all'),'all','%',:p_section)
AND info.DESIGNATION LIKE DECODE(NVL(:p_desig,'all'),'all','%',:p_desig)
AND info.WORKERTYPE LIKE DECODE(NVL(:p_worker,'all'),'all','%',:p_worker)
AND info.FLOORNO LIKE DECODE(NVL(:p_floorno,'all'),'all','%',:p_floorno)
AND info.MACHINENO LIKE DECODE(NVL(:p_machineno,'all'),'all','%',:p_machineno)
AND info.lineno LIKE DECODE(NVL(:p_lineno,'all'),'all','%',:p_lineno)
AND info.SHIFT LIKE DECODE(NVL(:p_shift,'all'),'all','%',:p_shift)
and info.GENDER LIKE DECODE(nvl(:p_gender,'all'),'all','%',:p_gender)
and info.active LIKE DECODE(NVL(:p_active,'all'),'all','%',:p_active)
AND info.cardno LIKE DECODE(NVL(:p_cardno,'all'),'all','%',:p_cardno)
order by info.cardno asc
---------------------------
select info.CARDNO, info.JOINING_DATE ,info.ENMNAME_BANGLA, info.DESIGNATION_BANGLA,
info.DEPT_BANGLA, info.SEC_BANGLA,INFO.COMPANY, info.FATHER_NAME_BAN, loan.LOAN_AMT
from TB_ADVANCEORLOAN_MASTER loan, tb_personal_info info
where loan.company = :p_company
and loan.LOANYEAR = :p_year
and loan.LOANMONTH = :p_month
and loan.LOANDATE = :p_loan_date
and loan.LOAN_TYPE = 'Loan'
and info.company = loan.company
and info.CARDNO = loan.CARDNO
AND loan.REASON_STATUS LIKE DECODE(NVL(:p_status,'all'),'all','%',:p_status)
AND info.DEPARTMENTNM LIKE DECODE(NVL(:p_deptname,'all'),'all','%',:p_deptname)
AND info.SECTIONNM LIKE DECODE(NVL(:p_section,'all'),'all','%',:p_section)
AND info.DESIGNATION LIKE DECODE(NVL(:p_desig,'all'),'all','%',:p_desig)
AND info.WORKERTYPE LIKE DECODE(NVL(:p_worker,'all'),'all','%',:p_worker)
AND info.FLOORNO LIKE DECODE(NVL(:p_floorno,'all'),'all','%',:p_floorno)
AND info.MACHINENO LIKE DECODE(NVL(:p_machineno,'all'),'all','%',:p_machineno)
AND info.lineno LIKE DECODE(NVL(:p_lineno,'all'),'all','%',:p_lineno)
AND info.SHIFT LIKE DECODE(NVL(:p_shift,'all'),'all','%',:p_shift)
and info.GENDER LIKE DECODE(nvl(:p_gender,'all'),'all','%',:p_gender)
and info.active LIKE DECODE(NVL(:p_active,'all'),'all','%',:p_active)
AND info.cardno LIKE DECODE(NVL(:p_cardno,'all'),'all','%',:p_cardno)
order by info.cardno asc