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.

[Home] [Help]

APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on FND_NUMBER

Line 390: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

386: /*
387: CURSOR cur_assignment_action_till_apr(c_ppsn varchar2
388: ,c_assignment_id per_all_assignments.assignment_id%type
389: ,c_person_id per_all_people_f.person_id%type) is
390: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
391: paa.assignment_action_id),16))
392: FROM pay_assignment_actions paa,pay_payroll_actions ppa
393: WHERE ((c_ppsn is null and paa.assignment_id=c_assignment_id)
394: OR(c_ppsn is not null and paa.assignment_id in (select paaf.assignment_id

Line 410: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

406: */
407:
408: CURSOR cur_assignment_action_till_apr(c_assignment_id per_all_assignments.assignment_id%type
409: ) is
410: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
411: paa.assignment_action_id),16))
412: FROM pay_assignment_actions paa
413: ,pay_payroll_actions ppa
414: WHERE paa.assignment_id=c_assignment_id

Line 423: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

419: AND ppa.effective_date<= to_date('30/04'||'/'||to_char(cp_end_date,'yyyy'),'dd/mm/yyyy');
420:
421: CURSOR cur_assignment_action(c_assignment_id per_all_assignments.assignment_id%type
422: ) is
423: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
424: paa.assignment_action_id),16))
425: FROM pay_assignment_actions paa
426: ,pay_payroll_actions ppa
427: WHERE paa.assignment_id=c_assignment_id

Line 507: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

503:
504: /* 9560108 */
505: --
506: CURSOR c_get_max_aact(p_pds_id NUMBER, c_person_id NUMBER) IS
507: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
508: paa.assignment_action_id),16))
509: FROM pay_assignment_Actions paa,
510: pay_payroll_actions ppa
511:

Line 525: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

521:
522: CURSOR c_get_max_aact_ppsn(p_pds_id NUMBER, /* 9560108 */
523: c_ppsn varchar2,
524: c_person_id NUMBER) IS
525: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
526: paa.assignment_action_id),16))
527: FROM pay_assignment_Actions paa,
528: pay_payroll_actions ppa
529:

Line 994: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(p60.total_gross_pay,0)) ,'9999999')),7,' ') ||'';

990: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| test_XML(p60.first_name) ||'';
991: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| p60.ppsn ||'';
992: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| p60.works_num ||'';
993: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| p60.hire_date ||'';
994: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(p60.total_gross_pay,0)) ,'9999999')),7,' ') ||'';
995: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.total_income_levy ,0)) ,'999990.99')),8,' ') ||'';
996: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_till_apr,0)) ,'9999999')),7,' ') ||'';
997: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_till_apr,0)) ,'999990.99')),8,' ') ||'';
998: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_frm_may,0)) ,'9999999')),7,' ') ||'';

Line 995: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.total_income_levy ,0)) ,'999990.99')),8,' ') ||'';

991: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| p60.ppsn ||'';
992: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| p60.works_num ||'';
993: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| p60.hire_date ||'';
994: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(p60.total_gross_pay,0)) ,'9999999')),7,' ') ||'';
995: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.total_income_levy ,0)) ,'999990.99')),8,' ') ||'';
996: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_till_apr,0)) ,'9999999')),7,' ') ||'';
997: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_till_apr,0)) ,'999990.99')),8,' ') ||'';
998: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_frm_may,0)) ,'9999999')),7,' ') ||'';
999: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_frm_may,0)) ,'999990.99')),8,' ') ||'';

Line 996: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_till_apr,0)) ,'9999999')),7,' ') ||'';

992: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| p60.works_num ||'';
993: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| p60.hire_date ||'';
994: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(p60.total_gross_pay,0)) ,'9999999')),7,' ') ||'';
995: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.total_income_levy ,0)) ,'999990.99')),8,' ') ||'';
996: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_till_apr,0)) ,'9999999')),7,' ') ||'';
997: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_till_apr,0)) ,'999990.99')),8,' ') ||'';
998: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_frm_may,0)) ,'9999999')),7,' ') ||'';
999: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_frm_may,0)) ,'999990.99')),8,' ') ||'';
1000: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| test_XML(p60.Employer_name) ||'';

Line 997: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_till_apr,0)) ,'999990.99')),8,' ') ||'';

993: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| p60.hire_date ||'';
994: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(p60.total_gross_pay,0)) ,'9999999')),7,' ') ||'';
995: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.total_income_levy ,0)) ,'999990.99')),8,' ') ||'';
996: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_till_apr,0)) ,'9999999')),7,' ') ||'';
997: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_till_apr,0)) ,'999990.99')),8,' ') ||'';
998: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_frm_may,0)) ,'9999999')),7,' ') ||'';
999: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_frm_may,0)) ,'999990.99')),8,' ') ||'';
1000: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| test_XML(p60.Employer_name) ||'';
1001: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| l_er_address_line1 ||''; -- 10277535

Line 998: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_frm_may,0)) ,'9999999')),7,' ') ||'';

994: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(p60.total_gross_pay,0)) ,'9999999')),7,' ') ||'';
995: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.total_income_levy ,0)) ,'999990.99')),8,' ') ||'';
996: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_till_apr,0)) ,'9999999')),7,' ') ||'';
997: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_till_apr,0)) ,'999990.99')),8,' ') ||'';
998: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_frm_may,0)) ,'9999999')),7,' ') ||'';
999: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_frm_may,0)) ,'999990.99')),8,' ') ||'';
1000: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| test_XML(p60.Employer_name) ||'';
1001: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| l_er_address_line1 ||''; -- 10277535
1002: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| l_er_address_line2 ||''; -- 10277535

Line 999: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_frm_may,0)) ,'999990.99')),8,' ') ||'';

995: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.total_income_levy ,0)) ,'999990.99')),8,' ') ||'';
996: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_till_apr,0)) ,'9999999')),7,' ') ||'';
997: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_till_apr,0)) ,'999990.99')),8,' ') ||'';
998: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_frm_may,0)) ,'9999999')),7,' ') ||'';
999: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_frm_may,0)) ,'999990.99')),8,' ') ||'';
1000: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| test_XML(p60.Employer_name) ||'';
1001: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| l_er_address_line1 ||''; -- 10277535
1002: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| l_er_address_line2 ||''; -- 10277535
1003: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| l_er_address_line3 ||''; -- 10277535