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_IE_CESS_REPORT dependencies on FND_NUMBER

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

383:
384: c_employee_details_rec c_employee_details%ROWTYPE;
385: /*8615992 */
386: CURSOR cur_assignment_action_apr_09(c_ppsn varchar2) is
387: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
388: paa.assignment_action_id),16))
389: FROM pay_assignment_actions paa
390: ,pay_payroll_actions ppa
391: -- ,pay_assignment_actions paa1

Line 1491: , p_action_information25 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09+l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* 9337590 */

1487: , p_action_information23 => lpad(upper(c_employee_details_rec.works_no), 9, ' ') -- works_no
1488: , p_action_information24 => fnd_date.date_to_canonical(c_employee_details_rec.hire_date)
1489:
1490: /* 8615992 */
1491: , p_action_information25 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09+l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* 9337590 */
1492: , p_action_information26 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09+l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* 9337590 */
1493: , p_action_information27 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1494: , p_action_information28 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1495: , p_action_information29 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */

Line 1492: , p_action_information26 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09+l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* 9337590 */

1488: , p_action_information24 => fnd_date.date_to_canonical(c_employee_details_rec.hire_date)
1489:
1490: /* 8615992 */
1491: , p_action_information25 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09+l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* 9337590 */
1492: , p_action_information26 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09+l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* 9337590 */
1493: , p_action_information27 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1494: , p_action_information28 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1495: , p_action_information29 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1496: , p_action_information30 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */

Line 1493: , p_action_information27 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */

1489:
1490: /* 8615992 */
1491: , p_action_information25 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09+l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* 9337590 */
1492: , p_action_information26 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09+l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* 9337590 */
1493: , p_action_information27 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1494: , p_action_information28 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1495: , p_action_information29 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1496: , p_action_information30 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1497: , p_action_information17 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_usc,0)) ,'999990.99')),8,' ') --USC

Line 1494: , p_action_information28 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */

1490: /* 8615992 */
1491: , p_action_information25 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09+l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* 9337590 */
1492: , p_action_information26 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09+l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* 9337590 */
1493: , p_action_information27 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1494: , p_action_information28 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1495: , p_action_information29 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1496: , p_action_information30 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1497: , p_action_information17 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_usc,0)) ,'999990.99')),8,' ') --USC
1498: , p_action_information18 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_uscable,0)) ,'9999999')),7,' ') --GROSS USCable

Line 1495: , p_action_information29 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */

1491: , p_action_information25 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09+l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* 9337590 */
1492: , p_action_information26 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09+l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* 9337590 */
1493: , p_action_information27 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1494: , p_action_information28 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1495: , p_action_information29 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1496: , p_action_information30 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1497: , p_action_information17 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_usc,0)) ,'999990.99')),8,' ') --USC
1498: , p_action_information18 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_uscable,0)) ,'9999999')),7,' ') --GROSS USCable
1499:

Line 1496: , p_action_information30 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */

1492: , p_action_information26 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09+l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* 9337590 */
1493: , p_action_information27 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1494: , p_action_information28 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1495: , p_action_information29 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1496: , p_action_information30 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1497: , p_action_information17 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_usc,0)) ,'999990.99')),8,' ') --USC
1498: , p_action_information18 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_uscable,0)) ,'9999999')),7,' ') --GROSS USCable
1499:
1500:

Line 1497: , p_action_information17 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_usc,0)) ,'999990.99')),8,' ') --USC

1493: , p_action_information27 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total_apr_09,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1494: , p_action_information28 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1495: , p_action_information29 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1496: , p_action_information30 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1497: , p_action_information17 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_usc,0)) ,'999990.99')),8,' ') --USC
1498: , p_action_information18 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_uscable,0)) ,'9999999')),7,' ') --GROSS USCable
1499:
1500:
1501: );

Line 1498: , p_action_information18 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_uscable,0)) ,'9999999')),7,' ') --GROSS USCable

1494: , p_action_information28 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy_apr_09,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1495: , p_action_information29 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_pay_total,0)) ,'9999999')),7,' ') -- lpad(l_gross_pay_total,10,' ') /* knadhan */
1496: , p_action_information30 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_income_levy,0)) ,'999990.99')),8,' ') -- lpad(l_income_levy,10,' ') /* knadhan */
1497: , p_action_information17 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_usc,0)) ,'999990.99')),8,' ') --USC
1498: , p_action_information18 => lpad(trim(to_char(fnd_number.canonical_to_number(nvl(l_gross_uscable,0)) ,'9999999')),7,' ') --GROSS USCable
1499:
1500:
1501: );
1502: --

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

2048: CURSOR cur_child_pay_action (p_person_id IN NUMBER,
2049: p_effective_date IN DATE,
2050: p_lat_act_seq IN NUMBER) is
2051: SELECT /*+ USE_NL(paa, ppa) */
2052: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2053: paa.assignment_action_id),16))
2054: FROM pay_assignment_actions paa,
2055: pay_payroll_actions ppa
2056: WHERE paa.payroll_action_id = ppa.payroll_action_id

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

2093:
2094: -- Cursor to fetch action context id of cess for previous period of service.
2095:
2096: CURSOR cur_get_last_cess(p_person_id NUMBER,p_termination_date DATE,p_pact NUMBER, c_assignment_id NUMBER,c_ppsn varchar2) IS
2097: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2098: paa.assignment_action_id),16))
2099: FROM pay_payroll_actions ppa,
2100: pay_assignment_actions paa,
2101: pay_action_information pai

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

2145: p_effective_date IN DATE,
2146: p_lat_act_seq IN NUMBER,
2147: c_ppsn_override per_assignment_extra_info.aei_information1%type) is
2148: SELECT /*+ USE_NL(paa, ppa) */
2149: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2150: paa.assignment_action_id),16))
2151: FROM pay_assignment_actions paa,
2152: pay_payroll_actions ppa
2153: WHERE paa.payroll_action_id = ppa.payroll_action_id