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_DATE

Line 182: select fnd_date.canonical_to_date(act_inf.action_information3)

178:
179:
180:
181: cursor cur_supp_run is
182: select fnd_date.canonical_to_date(act_inf.action_information3)
183: from pay_assignment_actions paa_run,
184: pay_action_interlocks pai,
185: pay_assignment_actions paa,
186: pay_payroll_actions ppa,

Line 1473: , p_action_information3 => fnd_date.date_to_canonical(l_termination_date)

1469: , p_source_text => NULL
1470: , p_action_information_category => 'IE CESS INFORMATION'
1471: -- , p_action_information1 => p_deceased_flag /* knadhan */
1472: , p_action_information2 => l_supp_flg
1473: , p_action_information3 => fnd_date.date_to_canonical(l_termination_date)
1474: , p_action_information7 => l_supp_pymt_date
1475: , p_action_information8 => p_person_id
1476: , p_action_information9 => fnd_date.date_to_canonical(p_date_earned)
1477: , p_action_information10 => upper(csr_get_org_tax_address_rec.employer_tax_rep_name)

Line 1476: , p_action_information9 => fnd_date.date_to_canonical(p_date_earned)

1472: , p_action_information2 => l_supp_flg
1473: , p_action_information3 => fnd_date.date_to_canonical(l_termination_date)
1474: , p_action_information7 => l_supp_pymt_date
1475: , p_action_information8 => p_person_id
1476: , p_action_information9 => fnd_date.date_to_canonical(p_date_earned)
1477: , p_action_information10 => upper(csr_get_org_tax_address_rec.employer_tax_rep_name)
1478: , p_action_information11 => upper(csr_get_org_tax_address_rec.employer_tax_addr1)
1479: , p_action_information12 => upper(csr_get_org_tax_address_rec.employer_tax_addr2)
1480: , p_action_information13 => upper(csr_get_org_tax_address_rec.employer_tax_addr3)

Line 1488: , p_action_information24 => fnd_date.date_to_canonical(c_employee_details_rec.hire_date)

1484: , p_action_information20 => upper(c_employee_details_rec.surname) -- surname
1485: , p_action_information21 => upper(c_employee_details_rec.first_name) -- first_name
1486: , p_action_information22 => upper(nvl(l_ppsn_override,c_employee_details_rec.PPSN)) -- PPSN
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 */

Line 2106: AND fnd_date.canonical_to_date(pai.action_information3) between trunc(p_termination_date,'Y') and p_termination_date

2102: WHERE paa.assignment_action_id = pai.action_context_id
2103: AND pai.action_information_category = 'IE CESS INFORMATION'
2104: AND pai.action_context_type = 'AAP'
2105: AND paa.tax_unit_id = g_paye_ref
2106: AND fnd_date.canonical_to_date(pai.action_information3) between trunc(p_termination_date,'Y') and p_termination_date
2107: AND ppa.payroll_action_id = paa.payroll_action_id
2108: AND ppa.report_type = 'IE_CESSATION'
2109: AND ppa.report_category = 'ARCHIVE'
2110: AND ppa.report_qualifier = 'IE'

Line 2511: IF to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_commencement),'rrrr'))= to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_paid),'YYYY')) THEN -- greater than 2009 /* knadhan */

2507: l_string := l_string ||''|| test_XML(cur_cess_emp_details_rec.last_name) ||'';
2508: l_string := l_string ||''||test_XML( cur_cess_emp_details_rec.first_name) ||'';
2509: l_string := l_string ||''|| cur_cess_emp_details_rec.pps_no ||'';
2510: l_string := l_string ||''|| cur_cess_emp_details_rec.works_no ||'';
2511: IF to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_commencement),'rrrr'))= to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_paid),'YYYY')) THEN -- greater than 2009 /* knadhan */
2512: l_string := l_string ||''|| to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_commencement),'ddmmrr') ||'';
2513: END IF;
2514: --IF (to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_leaving),'yyyy'))>=2009) THEN -- greater than 2009 /* knadhan */
2515: l_string := l_string ||''|| to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_leaving),'ddmmrr') ||'';

Line 2512: l_string := l_string ||''|| to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_commencement),'ddmmrr') ||'';

2508: l_string := l_string ||''||test_XML( cur_cess_emp_details_rec.first_name) ||'';
2509: l_string := l_string ||''|| cur_cess_emp_details_rec.pps_no ||'';
2510: l_string := l_string ||''|| cur_cess_emp_details_rec.works_no ||'';
2511: IF to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_commencement),'rrrr'))= to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_paid),'YYYY')) THEN -- greater than 2009 /* knadhan */
2512: l_string := l_string ||''|| to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_commencement),'ddmmrr') ||'';
2513: END IF;
2514: --IF (to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_leaving),'yyyy'))>=2009) THEN -- greater than 2009 /* knadhan */
2515: l_string := l_string ||''|| to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_leaving),'ddmmrr') ||'';
2516: --END IF;

Line 2514: --IF (to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_leaving),'yyyy'))>=2009) THEN -- greater than 2009 /* knadhan */

2510: l_string := l_string ||''|| cur_cess_emp_details_rec.works_no ||'';
2511: IF to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_commencement),'rrrr'))= to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_paid),'YYYY')) THEN -- greater than 2009 /* knadhan */
2512: l_string := l_string ||''|| to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_commencement),'ddmmrr') ||'';
2513: END IF;
2514: --IF (to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_leaving),'yyyy'))>=2009) THEN -- greater than 2009 /* knadhan */
2515: l_string := l_string ||''|| to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_leaving),'ddmmrr') ||'';
2516: --END IF;
2517: /* 8615992 */
2518: l_string := l_string ||''|| cur_cess_emp_details_rec.supplementary_flag ||'';

Line 2515: l_string := l_string ||''|| to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_leaving),'ddmmrr') ||'';

2511: IF to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_commencement),'rrrr'))= to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_paid),'YYYY')) THEN -- greater than 2009 /* knadhan */
2512: l_string := l_string ||''|| to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_commencement),'ddmmrr') ||'';
2513: END IF;
2514: --IF (to_number(to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_leaving),'yyyy'))>=2009) THEN -- greater than 2009 /* knadhan */
2515: l_string := l_string ||''|| to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_of_leaving),'ddmmrr') ||'';
2516: --END IF;
2517: /* 8615992 */
2518: l_string := l_string ||''|| cur_cess_emp_details_rec.supplementary_flag ||'';
2519: l_string := l_string ||''|| cur_cess_emp_details_rec.gross_pay_total_final ||'';

Line 2532: l_string := l_string ||''||to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_paid),'YYYY') ||''; /* 9337590 */

2528: l_string := l_string ||''||test_XML(cur_cess_emp_details_rec.employer_tax_addr3) ||'';
2529: l_string := l_string ||''|| cur_cess_emp_details_rec.email ||''; /* knadhan */
2530: l_string := l_string ||''|| cur_cess_emp_details_rec.employer_no ||'';
2531: l_string := l_string ||''||cur_cess_emp_details_rec.employer_tax_ref_phone||'';
2532: l_string := l_string ||''||to_char(fnd_date.canonical_to_date(cur_cess_emp_details_rec.date_paid),'YYYY') ||''; /* 9337590 */
2533: l_string := l_string ||''|| cur_cess_emp_details_rec.usc||''; /* USC */
2534: l_string := l_string ||''|| cur_cess_emp_details_rec.gross_uscable||''; /* USCable (Gross - Court Order) */
2535:
2536: l_string := l_string ||'';