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 491: ,fnd_number.canonical_to_number(pai.action_information5) rate

487: ,p_min_sal NUMBER
488: ,p_max_sal NUMBER)
489: IS
490: SELECT COUNT(*) count
491: ,fnd_number.canonical_to_number(pai.action_information5) rate
492: FROM pay_action_information pai
493: WHERE pai.jurisdiction_code = 'MH'
494: AND pai.source_id = p_source_id
495: AND pai.action_information_category = 'IN_PT_ASG'

Line 509: AND fnd_number.canonical_to_number(pai.action_information4) BETWEEN p_min_sal and p_max_sal

505: AND action_context_type = 'AAP'
506: AND action_information_category = 'IN_PT_ASG'
507: AND jurisdiction_code = 'MH'
508: AND source_id = p_source_id)
509: AND fnd_number.canonical_to_number(pai.action_information4) BETWEEN p_min_sal and p_max_sal
510: GROUP BY pai.action_information5
511: ORDER BY pai.action_information5;
512:
513: CURSOR cur_sal_range(p_period_start date)

Line 515: SELECT fnd_number.canonical_to_number(row_low_range_or_name) min_sal,

511: ORDER BY pai.action_information5;
512:
513: CURSOR cur_sal_range(p_period_start date)
514: IS
515: SELECT fnd_number.canonical_to_number(row_low_range_or_name) min_sal,
516: fnd_number.canonical_to_number(row_high_range) max_sal
517: FROM pay_user_rows_f
518: WHERE user_table_id IN (SELECT user_table_id
519: FROM pay_user_tables

Line 516: fnd_number.canonical_to_number(row_high_range) max_sal

512:
513: CURSOR cur_sal_range(p_period_start date)
514: IS
515: SELECT fnd_number.canonical_to_number(row_low_range_or_name) min_sal,
516: fnd_number.canonical_to_number(row_high_range) max_sal
517: FROM pay_user_rows_f
518: WHERE user_table_id IN (SELECT user_table_id
519: FROM pay_user_tables
520: WHERE user_table_name LIKE 'India Professional Tax Rate for MH'

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

1197:
1198:
1199: CURSOR csr_tax_details(p_balance VARCHAR2,p_action_context_id NUMBER,p_source_id IN NUMBER)
1200: IS
1201: SELECT NVL(SUM(fnd_number.canonical_to_number(action_information2)),0)
1202: FROM pay_action_information
1203: WHERE action_information_category = 'IN_EOY_ASG_SAL'
1204: AND action_context_type = 'AAP'
1205: AND action_information1 = p_balance

Line 1506: ORDER BY substr(paa_asg.action_information3 ,instr(paa_asg.action_information3,'/',-1)+1 ),fnd_number.canonical_to_number(paa_asg.action_information7) ASC;

1502: AND paa_pay.action_information2=p_pf_org_id
1503: AND substr(paa_asg.action_information3 ,instr(paa_asg.action_information3,'/',-1)+1 )=p_pf_number
1504: AND paa_asg.action_information4 = p_member_name
1505: AND to_number(to_char(to_date(paa_asg.action_information13,'DD/MM/YY'),'MM'))=p_mon_number
1506: ORDER BY substr(paa_asg.action_information3 ,instr(paa_asg.action_information3,'/',-1)+1 ),fnd_number.canonical_to_number(paa_asg.action_information7) ASC;
1507:
1508:
1509: l_mon NUMBER;
1510: l_leave DATE;

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

2117: /* Bugfix 4253674 and 4270904 Start*/
2118:
2119: /*Find the global value as on Financial year start */
2120: CURSOR csr_global_value(p_name VARCHAR2) IS
2121: SELECT fnd_number.canonical_to_number(glb.global_value)
2122: FROM ff_globals_f glb
2123: WHERE glb.global_name = p_name
2124: AND glb.LEGISLATION_CODE ='IN'
2125: AND p_effective_end_date BETWEEN glb.effective_start_date and glb.effective_end_date;

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

2145: ,p_pension_number VARCHAR2
2146: ,p_pf_salary_ceiling NUMBER)
2147: IS
2148: SELECT
2149: SUM(fnd_number.canonical_to_number(pai_mas.action_information10)) pension
2150: FROM pay_action_information pai_mas
2151: where pai_mas.action_information_category ='IN_PF_ASG'
2152: and pai_mas.action_information1 = p_contribution_period
2153: and pai_mas.action_information2 = p_pf_org_id

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

2179: CURSOR c_pf_employer(p_pf_org_id VARCHAR2
2180: ,p_effective_start_date DATE
2181: ,p_effective_end_date DATE)
2182: IS
2183: SELECT fnd_number.canonical_to_number(org_information2) mon --Month Number
2184: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
2185: FROM hr_organization_information
2186: WHERE organization_id = p_pf_org_id
2187: AND ORG_INFORMATION_CONTEXT = 'PER_IN_PF_CHALLAN_INFO'

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

2180: ,p_effective_start_date DATE
2181: ,p_effective_end_date DATE)
2182: IS
2183: SELECT fnd_number.canonical_to_number(org_information2) mon --Month Number
2184: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
2185: FROM hr_organization_information
2186: WHERE organization_id = p_pf_org_id
2187: AND ORG_INFORMATION_CONTEXT = 'PER_IN_PF_CHALLAN_INFO'
2188: AND org_information1=TO_CHAR(p_effective_start_date,'YYYY')||'-'||TO_CHAR(p_effective_end_date,'YYYY')

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

2233: /*Added for Bug 5647738*/
2234: cursor c_monthly_contributions( p_pf_org_id NUMBER
2235: , p_pension_no varchar2)
2236: IS
2237: SELECT fnd_number.canonical_to_number(pai.action_information7) pf_wages
2238: ,pai.action_information13 date_earned
2239: FROM pay_action_information pai
2240: WHERE pai.action_information_category ='IN_PF_ASG'
2241: AND pai.action_information1 = p_contribution_period

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

3180: ,p_effective_start_date DATE
3181: ,p_effective_end_date DATE
3182: )
3183: IS
3184: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3185: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3186: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3187: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3188: FROM pay_action_information

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

3181: ,p_effective_end_date DATE
3182: )
3183: IS
3184: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3185: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3186: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3187: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3188: FROM pay_action_information
3189: WHERE action_information2 = p_pf_org_id

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

3182: )
3183: IS
3184: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3185: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3186: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3187: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3188: FROM pay_action_information
3189: WHERE action_information2 = p_pf_org_id
3190: AND action_information3 = p_pf_number

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

3183: IS
3184: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3185: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3186: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3187: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3188: FROM pay_action_information
3189: WHERE action_information2 = p_pf_org_id
3190: AND action_information3 = p_pf_number
3191: AND action_information1 = p_contribution_period

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

3253: )
3254: IS
3255: SELECT
3256: TO_NUMBER(org_information2) mon --Month Number
3257: ,SUM(fnd_number.canonical_to_number(org_information3)+fnd_number.canonical_to_number(org_information4)) epf
3258: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
3259: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
3260: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
3261: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2

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

3254: IS
3255: SELECT
3256: TO_NUMBER(org_information2) mon --Month Number
3257: ,SUM(fnd_number.canonical_to_number(org_information3)+fnd_number.canonical_to_number(org_information4)) epf
3258: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
3259: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
3260: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
3261: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
3262: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg

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

3255: SELECT
3256: TO_NUMBER(org_information2) mon --Month Number
3257: ,SUM(fnd_number.canonical_to_number(org_information3)+fnd_number.canonical_to_number(org_information4)) epf
3258: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
3259: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
3260: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
3261: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
3262: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg
3263: FROM hr_organization_information

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

3256: TO_NUMBER(org_information2) mon --Month Number
3257: ,SUM(fnd_number.canonical_to_number(org_information3)+fnd_number.canonical_to_number(org_information4)) epf
3258: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
3259: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
3260: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
3261: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
3262: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg
3263: FROM hr_organization_information
3264: WHERE organization_id=p_pf_org_id

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

3257: ,SUM(fnd_number.canonical_to_number(org_information3)+fnd_number.canonical_to_number(org_information4)) epf
3258: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
3259: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
3260: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
3261: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
3262: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg
3263: FROM hr_organization_information
3264: WHERE organization_id=p_pf_org_id
3265: AND ORG_INFORMATION_CONTEXT='PER_IN_PF_CHALLAN_INFO'

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

3258: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
3259: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
3260: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
3261: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
3262: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg
3263: FROM hr_organization_information
3264: WHERE organization_id=p_pf_org_id
3265: AND ORG_INFORMATION_CONTEXT='PER_IN_PF_CHALLAN_INFO'
3266: AND org_information1=to_char(p_effective_start_date,'YYYY')||'-'||to_char(p_effective_end_date,'YYYY')

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

3407: pay_in_utils.trace('PF Organization ',c_rec.action_information3);
3408: END IF;
3409:
3410: --Statuory Rate of Contribution
3411: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate
3412: FROM FF_GLOBALS_F
3413: WHERE GLOBAL_NAME ='IN_EMPLOYEE_PF_PERCENT'
3414: AND LEGISLATION_CODE='IN'
3415: AND p_effective_start_date BETWEEN effective_start_date AND p_effective_end_date;

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

3908: AND paa_asg.action_information3=p_pf_number
3909: AND paa_pay.action_information2=p_pf_org_id
3910: AND to_number(to_char(to_date(paa_asg.action_information13,'DD-MM-YY'),'MM'))=p_mon_number
3911: AND paa_asg.action_information13 BETWEEN p_effective_start_date AND p_effective_end_date
3912: ORDER BY to_date(paa_asg.action_information13,'DD-MM-YYYY'), fnd_number.canonical_to_number(paa_asg.action_information7) ASC;
3913:
3914: CURSOR c_asg_summation_details(p_pf_org_id VARCHAR2
3915: ,p_pf_number VARCHAR2
3916: ,p_effective_start_date DATE

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

3917: ,p_effective_end_date DATE
3918: ,p_contribution_period VARCHAR2
3919: )
3920: IS
3921: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3922: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3923: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3924: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3925: ,SUM(fnd_number.canonical_to_number(action_information8) + fnd_number.canonical_to_number(action_information9)) total --Total Employee Employer Contr

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

3918: ,p_contribution_period VARCHAR2
3919: )
3920: IS
3921: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3922: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3923: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3924: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3925: ,SUM(fnd_number.canonical_to_number(action_information8) + fnd_number.canonical_to_number(action_information9)) total --Total Employee Employer Contr
3926: FROM pay_action_information

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

3919: )
3920: IS
3921: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3922: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3923: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3924: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3925: ,SUM(fnd_number.canonical_to_number(action_information8) + fnd_number.canonical_to_number(action_information9)) total --Total Employee Employer Contr
3926: FROM pay_action_information
3927: WHERE action_information2 = p_pf_org_id

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

3920: IS
3921: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3922: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3923: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3924: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3925: ,SUM(fnd_number.canonical_to_number(action_information8) + fnd_number.canonical_to_number(action_information9)) total --Total Employee Employer Contr
3926: FROM pay_action_information
3927: WHERE action_information2 = p_pf_org_id
3928: AND action_information3 = p_pf_number

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

3921: SELECT SUM(fnd_number.canonical_to_number(action_information7)) pf_ytd --PF Salary
3922: ,SUM(fnd_number.canonical_to_number(action_information8)) employee --Total Employee Contr
3923: ,SUM(fnd_number.canonical_to_number(action_information9)) employer --Employer Contr towards PF
3924: ,SUM(fnd_number.canonical_to_number(action_information10)) pension --Employer Contr towards Pension
3925: ,SUM(fnd_number.canonical_to_number(action_information8) + fnd_number.canonical_to_number(action_information9)) total --Total Employee Employer Contr
3926: FROM pay_action_information
3927: WHERE action_information2 = p_pf_org_id
3928: AND action_information3 = p_pf_number
3929: AND action_information1 = p_contribution_period

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

4286: --Ending Year
4287: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
4288: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4289: --Statuory Rate of Contribution
4290: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate
4291: FROM FF_GLOBALS_F
4292: WHERE GLOBAL_NAME ='IN_EMPLOYEE_PF_PERCENT'
4293: AND LEGISLATION_CODE='IN'
4294: AND p_effective_start_date BETWEEN effective_start_date AND p_effective_end_date;

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

4480: /* 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*/
4481:
4482: /*Find the global value as on Financial year start */
4483: CURSOR csr_global_value(p_name VARCHAR2) IS
4484: SELECT fnd_number.canonical_to_number(glb.global_value)
4485: FROM ff_globals_f glb
4486: WHERE glb.global_name = p_name
4487: AND glb.LEGISLATION_CODE ='IN'
4488: AND p_effective_end_date BETWEEN glb.effective_start_date and glb.effective_end_date;

Line 5344: ,fnd_number.canonical_to_number(action_information6) actual_salary

5340: ,p_esi_org_id VARCHAR2
5341: ,p_payroll_date DATE)
5342: IS
5343: SELECT action_information4 full_name
5344: ,fnd_number.canonical_to_number(action_information6) actual_salary
5345: ,fnd_number.canonical_to_number(action_information7) employee_contr
5346: ,fnd_number.canonical_to_number(action_information8) employer_contr
5347: ,action_information9 esi_coverage
5348: ,action_information11 payroll_date

Line 5345: ,fnd_number.canonical_to_number(action_information7) employee_contr

5341: ,p_payroll_date DATE)
5342: IS
5343: SELECT action_information4 full_name
5344: ,fnd_number.canonical_to_number(action_information6) actual_salary
5345: ,fnd_number.canonical_to_number(action_information7) employee_contr
5346: ,fnd_number.canonical_to_number(action_information8) employer_contr
5347: ,action_information9 esi_coverage
5348: ,action_information11 payroll_date
5349: FROM pay_action_information

Line 5346: ,fnd_number.canonical_to_number(action_information8) employer_contr

5342: IS
5343: SELECT action_information4 full_name
5344: ,fnd_number.canonical_to_number(action_information6) actual_salary
5345: ,fnd_number.canonical_to_number(action_information7) employee_contr
5346: ,fnd_number.canonical_to_number(action_information8) employer_contr
5347: ,action_information9 esi_coverage
5348: ,action_information11 payroll_date
5349: FROM pay_action_information
5350: WHERE action_information_category='IN_ESI_ASG'

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

5352: AND action_information1=p_contribution_period
5353: AND action_information2=p_esi_org_id
5354: AND action_information3=p_insurance_no
5355: AND to_date(action_information11,'DD-MM-YY')=p_payroll_date
5356: ORDER BY to_date(action_information11,'DD-MM-YYYY') DESC ,fnd_number.canonical_to_number(action_information6)DESC;
5357:
5358: --Cursor to find the absence details
5359: CURSOR c_absence(p_insurance_no VARCHAR2
5360: ,p_esi_org_id VARCHAR2)

Line 5420: ,fnd_number.canonical_to_number(org_information3) challan_amt

5416: --Challan Information
5417: CURSOR c_challan(p_esi_org_id VARCHAR2)
5418: IS
5419: SELECT fnd_date.CANONICAL_TO_DATE(org_information2) challan_date
5420: ,fnd_number.canonical_to_number(org_information3) challan_amt
5421: ,org_information5 challan_bank_code
5422: ,org_information6 challan_branch_code
5423: ,hr_general.decode_lookup('IN_ESI_BANKS',org_information5) challan_bank
5424: ,hr_general.decode_lookup('IN_CALENDAR_MONTH',org_information7) month