eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_REPORTS_PKG dependencies on FND_NUMBER

Line 475: SELECT NVL(SUM(fnd_number.canonical_to_number(org_information5)),0) challan_amt

471: CURSOR c_challan(p_pt_org_id NUMBER
472: ,p_period_start DATE
473: ,p_period_end DATE)
474: IS
475: SELECT NVL(SUM(fnd_number.canonical_to_number(org_information5)),0) challan_amt
476: ,NVL(SUM(fnd_number.canonical_to_number(org_information6)),0) interest_amt
477: ,NVL(SUM(fnd_number.canonical_to_number(org_information8)),0) excess_amt
478: FROM hr_organization_information
479: WHERE organization_id = p_pt_org_id

Line 476: ,NVL(SUM(fnd_number.canonical_to_number(org_information6)),0) interest_amt

472: ,p_period_start DATE
473: ,p_period_end DATE)
474: IS
475: SELECT NVL(SUM(fnd_number.canonical_to_number(org_information5)),0) challan_amt
476: ,NVL(SUM(fnd_number.canonical_to_number(org_information6)),0) interest_amt
477: ,NVL(SUM(fnd_number.canonical_to_number(org_information8)),0) excess_amt
478: FROM hr_organization_information
479: WHERE organization_id = p_pt_org_id
480: AND org_information_context = 'PER_IN_PT_CHALLAN_INFO'

Line 477: ,NVL(SUM(fnd_number.canonical_to_number(org_information8)),0) excess_amt

473: ,p_period_end DATE)
474: IS
475: SELECT NVL(SUM(fnd_number.canonical_to_number(org_information5)),0) challan_amt
476: ,NVL(SUM(fnd_number.canonical_to_number(org_information6)),0) interest_amt
477: ,NVL(SUM(fnd_number.canonical_to_number(org_information8)),0) excess_amt
478: FROM hr_organization_information
479: WHERE organization_id = p_pt_org_id
480: AND org_information_context = 'PER_IN_PT_CHALLAN_INFO'
481: AND ADD_MONTHS(TO_DATE('01-'|| org_information1 || SUBSTR(org_information9, 1, 4), 'DD-MM-YYYY'), 3)

Line 489: ,fnd_number.canonical_to_number(pai.action_information5) rate

485: ,p_year VARCHAR2
486: ,p_month NUMBER)
487: IS
488: SELECT COUNT(*) count
489: ,fnd_number.canonical_to_number(pai.action_information5) rate
490: FROM pay_action_information pai
491: WHERE pai.jurisdiction_code = 'MH'
492: AND pai.source_id = p_source_id
493: AND pai.action_information_category = 'IN_PT_ASG'

Line 1121: SELECT NVL(SUM(fnd_number.canonical_to_number(action_information2)),0)

1117:
1118:
1119: CURSOR csr_tax_details(p_balance VARCHAR2,p_action_context_id NUMBER,p_source_id IN NUMBER)
1120: IS
1121: SELECT NVL(SUM(fnd_number.canonical_to_number(action_information2)),0)
1122: FROM pay_action_information
1123: WHERE action_information_category = 'IN_EOY_ASG_SAL'
1124: AND action_context_type = 'AAP'
1125: AND action_information1 = p_balance

Line 1540: SELECT fnd_number.canonical_to_number(glb.global_value)

1536: /* Bugfix 4253674 and 4270904 Start*/
1537:
1538: /*Find the global value as on Financial year start */
1539: CURSOR csr_global_value(p_name VARCHAR2) IS
1540: SELECT fnd_number.canonical_to_number(glb.global_value)
1541: FROM ff_globals_f glb
1542: WHERE glb.global_name = p_name
1543: AND glb.LEGISLATION_CODE ='IN'
1544: AND p_effective_end_date BETWEEN glb.effective_start_date and glb.effective_end_date;

Line 1568: SUM(fnd_number.canonical_to_number(pai_mas.action_information10)) pension

1564: ,p_pension_number VARCHAR2
1565: ,p_pf_salary_ceiling NUMBER)
1566: IS
1567: SELECT
1568: SUM(fnd_number.canonical_to_number(pai_mas.action_information10)) pension
1569: FROM pay_action_information pai_mas
1570: where pai_mas.action_information_category ='IN_PF_ASG'
1571: and pai_mas.action_information1 = p_contribution_period
1572: and pai_mas.action_information2 = p_pf_org_id

Line 1602: SELECT fnd_number.canonical_to_number(org_information2) mon --Month Number

1598: CURSOR c_pf_employer(p_pf_org_id VARCHAR2
1599: ,p_effective_start_date DATE
1600: ,p_effective_end_date DATE)
1601: IS
1602: SELECT fnd_number.canonical_to_number(org_information2) mon --Month Number
1603: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
1604: FROM hr_organization_information
1605: WHERE organization_id = p_pf_org_id
1606: AND ORG_INFORMATION_CONTEXT = 'PER_IN_PF_CHALLAN_INFO'

Line 1603: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10

1599: ,p_effective_start_date DATE
1600: ,p_effective_end_date DATE)
1601: IS
1602: SELECT fnd_number.canonical_to_number(org_information2) mon --Month Number
1603: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
1604: FROM hr_organization_information
1605: WHERE organization_id = p_pf_org_id
1606: AND ORG_INFORMATION_CONTEXT = 'PER_IN_PF_CHALLAN_INFO'
1607: AND org_information1=TO_CHAR(p_effective_start_date,'YYYY')||'-'||TO_CHAR(p_effective_end_date,'YYYY')

Line 1656: SELECT fnd_number.canonical_to_number(pai.action_information7) pf_wages

1652: /*Added for Bug 5647738*/
1653: cursor c_monthly_contributions( p_pf_org_id NUMBER
1654: , p_pension_no varchar2)
1655: IS
1656: SELECT fnd_number.canonical_to_number(pai.action_information7) pf_wages
1657: ,pai.action_information13 date_earned
1658: FROM pay_action_information pai
1659: WHERE pai.action_information_category ='IN_PF_ASG'
1660: AND pai.action_information1 = p_contribution_period

Line 2595: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary

2591: ,p_effective_start_date DATE
2592: ,p_effective_end_date DATE
2593: )
2594: IS
2595: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
2596: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
2597: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
2598: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
2599: FROM pay_action_information

Line 2596: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr

2592: ,p_effective_end_date DATE
2593: )
2594: IS
2595: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
2596: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
2597: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
2598: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
2599: FROM pay_action_information
2600: WHERE action_information2 = p_pf_org_id

Line 2597: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF

2593: )
2594: IS
2595: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
2596: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
2597: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
2598: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
2599: FROM pay_action_information
2600: WHERE action_information2 = p_pf_org_id
2601: AND action_information3 = p_pf_number

Line 2598: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension

2594: IS
2595: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
2596: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
2597: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
2598: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
2599: FROM pay_action_information
2600: WHERE action_information2 = p_pf_org_id
2601: AND action_information3 = p_pf_number
2602: AND action_information1 = p_contribution_period

Line 2668: ,SUM(fnd_number.canonical_to_number(org_information3)+fnd_number.canonical_to_number(org_information4)) epf

2664: )
2665: IS
2666: SELECT
2667: TO_NUMBER(org_information2) mon --Month Number
2668: ,SUM(fnd_number.canonical_to_number(org_information3)+fnd_number.canonical_to_number(org_information4)) epf
2669: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
2670: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
2671: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
2672: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2

Line 2669: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10

2665: IS
2666: SELECT
2667: TO_NUMBER(org_information2) mon --Month Number
2668: ,SUM(fnd_number.canonical_to_number(org_information3)+fnd_number.canonical_to_number(org_information4)) epf
2669: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
2670: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
2671: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
2672: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
2673: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg

Line 2670: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21

2666: SELECT
2667: TO_NUMBER(org_information2) mon --Month Number
2668: ,SUM(fnd_number.canonical_to_number(org_information3)+fnd_number.canonical_to_number(org_information4)) epf
2669: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
2670: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
2671: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
2672: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
2673: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg
2674: FROM hr_organization_information

Line 2671: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22

2667: TO_NUMBER(org_information2) mon --Month Number
2668: ,SUM(fnd_number.canonical_to_number(org_information3)+fnd_number.canonical_to_number(org_information4)) epf
2669: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
2670: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
2671: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
2672: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
2673: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg
2674: FROM hr_organization_information
2675: WHERE organization_id=p_pf_org_id

Line 2672: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2

2668: ,SUM(fnd_number.canonical_to_number(org_information3)+fnd_number.canonical_to_number(org_information4)) epf
2669: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
2670: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
2671: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
2672: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
2673: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg
2674: FROM hr_organization_information
2675: WHERE organization_id=p_pf_org_id
2676: AND ORG_INFORMATION_CONTEXT='PER_IN_PF_CHALLAN_INFO'

Line 2673: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg

2669: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
2670: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
2671: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
2672: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
2673: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg
2674: FROM hr_organization_information
2675: WHERE organization_id=p_pf_org_id
2676: AND ORG_INFORMATION_CONTEXT='PER_IN_PF_CHALLAN_INFO'
2677: AND org_information1=to_char(p_effective_start_date,'YYYY')||'-'||to_char(p_effective_end_date,'YYYY')

Line 2821: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate

2817: pay_in_utils.trace('PF Organization ',c_rec.action_information3);
2818: END IF;
2819:
2820: --Statuory Rate of Contribution
2821: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate
2822: FROM FF_GLOBALS_F
2823: WHERE GLOBAL_NAME ='IN_EMPLOYEE_PF_PERCENT'
2824: AND LEGISLATION_CODE='IN'
2825: AND p_effective_start_date BETWEEN effective_start_date AND p_effective_end_date;

Line 3271: ORDER BY to_date(paa_asg.action_information13,'DD-MM-YYYY'), fnd_number.canonical_to_number(paa_asg.action_information7) ASC;

3267: AND paa_asg.action_information3=p_pf_number
3268: AND paa_pay.action_information2=p_pf_org_id
3269: AND to_number(to_char(to_date(paa_asg.action_information13,'DD-MM-YY'),'MM'))=p_mon_number
3270: AND paa_asg.action_information13 BETWEEN p_effective_start_date AND p_effective_end_date
3271: ORDER BY to_date(paa_asg.action_information13,'DD-MM-YYYY'), fnd_number.canonical_to_number(paa_asg.action_information7) ASC;
3272:
3273: CURSOR c_asg_summation_details(p_pf_org_id VARCHAR2
3274: ,p_pf_number VARCHAR2
3275: ,p_effective_start_date DATE

Line 3280: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary

3276: ,p_effective_end_date DATE
3277: ,p_contribution_period VARCHAR2
3278: )
3279: IS
3280: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3281: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3282: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3283: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3284: ,SUM(fnd_number.canonical_to_number(action_information8) + fnd_number.canonical_to_number(action_information9)) total --Total Employee Employer Contr

Line 3281: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr

3277: ,p_contribution_period VARCHAR2
3278: )
3279: IS
3280: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3281: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3282: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3283: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3284: ,SUM(fnd_number.canonical_to_number(action_information8) + fnd_number.canonical_to_number(action_information9)) total --Total Employee Employer Contr
3285: FROM pay_action_information

Line 3282: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF

3278: )
3279: IS
3280: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3281: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3282: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3283: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3284: ,SUM(fnd_number.canonical_to_number(action_information8) + fnd_number.canonical_to_number(action_information9)) total --Total Employee Employer Contr
3285: FROM pay_action_information
3286: WHERE action_information2 = p_pf_org_id

Line 3283: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension

3279: IS
3280: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3281: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3282: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3283: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3284: ,SUM(fnd_number.canonical_to_number(action_information8) + fnd_number.canonical_to_number(action_information9)) total --Total Employee Employer Contr
3285: FROM pay_action_information
3286: WHERE action_information2 = p_pf_org_id
3287: AND action_information3 = p_pf_number

Line 3284: ,SUM(fnd_number.canonical_to_number(action_information8) + fnd_number.canonical_to_number(action_information9)) total --Total Employee Employer Contr

3280: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3281: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3282: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3283: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3284: ,SUM(fnd_number.canonical_to_number(action_information8) + fnd_number.canonical_to_number(action_information9)) total --Total Employee Employer Contr
3285: FROM pay_action_information
3286: WHERE action_information2 = p_pf_org_id
3287: AND action_information3 = p_pf_number
3288: AND action_information1 = p_contribution_period

Line 3574: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate

3570: --Ending Year
3571: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
3572: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3573: --Statuory Rate of Contribution
3574: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate
3575: FROM FF_GLOBALS_F
3576: WHERE GLOBAL_NAME ='IN_EMPLOYEE_PF_PERCENT'
3577: AND LEGISLATION_CODE='IN'
3578: AND p_effective_start_date BETWEEN effective_start_date AND p_effective_end_date;

Line 3765: SELECT fnd_number.canonical_to_number(glb.global_value)

3761: /* No need of a separate cursor to find annual values as this wont work when multiple records are present for an employee in a single month for a single Organization*/
3762:
3763: /*Find the global value as on Financial year start */
3764: CURSOR csr_global_value(p_name VARCHAR2) IS
3765: SELECT fnd_number.canonical_to_number(glb.global_value)
3766: FROM ff_globals_f glb
3767: WHERE glb.global_name = p_name
3768: AND glb.LEGISLATION_CODE ='IN'
3769: AND p_effective_end_date BETWEEN glb.effective_start_date and glb.effective_end_date;

Line 4625: ,fnd_number.canonical_to_number(action_information6) actual_salary

4621: ,p_esi_org_id VARCHAR2
4622: ,p_payroll_date DATE)
4623: IS
4624: SELECT action_information4 full_name
4625: ,fnd_number.canonical_to_number(action_information6) actual_salary
4626: ,fnd_number.canonical_to_number(action_information7) employee_contr
4627: ,fnd_number.canonical_to_number(action_information8) employer_contr
4628: ,action_information9 esi_coverage
4629: ,action_information11 payroll_date

Line 4626: ,fnd_number.canonical_to_number(action_information7) employee_contr

4622: ,p_payroll_date DATE)
4623: IS
4624: SELECT action_information4 full_name
4625: ,fnd_number.canonical_to_number(action_information6) actual_salary
4626: ,fnd_number.canonical_to_number(action_information7) employee_contr
4627: ,fnd_number.canonical_to_number(action_information8) employer_contr
4628: ,action_information9 esi_coverage
4629: ,action_information11 payroll_date
4630: FROM pay_action_information

Line 4627: ,fnd_number.canonical_to_number(action_information8) employer_contr

4623: IS
4624: SELECT action_information4 full_name
4625: ,fnd_number.canonical_to_number(action_information6) actual_salary
4626: ,fnd_number.canonical_to_number(action_information7) employee_contr
4627: ,fnd_number.canonical_to_number(action_information8) employer_contr
4628: ,action_information9 esi_coverage
4629: ,action_information11 payroll_date
4630: FROM pay_action_information
4631: WHERE action_information_category='IN_ESI_ASG'

Line 4637: ORDER BY to_date(action_information11,'DD-MM-YYYY') DESC ,fnd_number.canonical_to_number(action_information6)DESC;

4633: AND action_information1=p_contribution_period
4634: AND action_information2=p_esi_org_id
4635: AND action_information3=p_insurance_no
4636: AND to_date(action_information11,'DD-MM-YY')=p_payroll_date
4637: ORDER BY to_date(action_information11,'DD-MM-YYYY') DESC ,fnd_number.canonical_to_number(action_information6)DESC;
4638:
4639: --Cursor to find the absence details
4640: CURSOR c_absence(p_insurance_no VARCHAR2
4641: ,p_esi_org_id VARCHAR2)

Line 4701: ,fnd_number.canonical_to_number(org_information3) challan_amt

4697: --Challan Information
4698: CURSOR c_challan(p_esi_org_id VARCHAR2)
4699: IS
4700: SELECT fnd_date.CANONICAL_TO_DATE(org_information2) challan_date
4701: ,fnd_number.canonical_to_number(org_information3) challan_amt
4702: ,org_information5 challan_bank_code
4703: ,org_information6 challan_branch_code
4704: ,hr_general.decode_lookup('IN_ESI_BANKS',org_information5) challan_bank
4705: ,hr_general.decode_lookup('IN_CALENDAR_MONTH',org_information7) month