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_FI_ARCHIVE_LTFA dependencies on FND_DATE

Line 225: AND csr_v_effective_date BETWEEN fnd_date.canonical_to_date(hoi3.org_information1) AND

221: AND hoi2.ORG_INFORMATION_CONTEXT='FI_LEGAL_EMPLOYER_DETAILS'
222: AND o1.organization_id =hoi3.organization_id
223: AND hoi3.ORG_INFORMATION_CONTEXT='FI_PENSION_PROVIDERS'
224: AND hoi3.org_information6=csr_v_pension_ins_num
225: AND csr_v_effective_date BETWEEN fnd_date.canonical_to_date(hoi3.org_information1) AND
226: nvl(fnd_date.canonical_to_date(hoi3.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
227:
228: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
229: /*

Line 226: nvl(fnd_date.canonical_to_date(hoi3.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;

222: AND o1.organization_id =hoi3.organization_id
223: AND hoi3.ORG_INFORMATION_CONTEXT='FI_PENSION_PROVIDERS'
224: AND hoi3.org_information6=csr_v_pension_ins_num
225: AND csr_v_effective_date BETWEEN fnd_date.canonical_to_date(hoi3.org_information1) AND
226: nvl(fnd_date.canonical_to_date(hoi3.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
227:
228: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
229: /*
230: Cursor csr_lu_pp_dtls ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE

Line 267: AND csr_v_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1) AND

263: AND o1.organization_id =hoi2.organization_id
264: AND hoi2.ORG_INFORMATION_CONTEXT='FI_PENSION_PROVIDERS'
265: AND hoi2.org_information3=csr_v_pension_type
266: AND hoi2.org_information4=csr_v_pension_provider
267: AND csr_v_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1) AND
268: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
269:
270:
271: rg_le_pp_dtls csr_le_pp_dtls%rowtype;

Line 268: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;

264: AND hoi2.ORG_INFORMATION_CONTEXT='FI_PENSION_PROVIDERS'
265: AND hoi2.org_information3=csr_v_pension_type
266: AND hoi2.org_information4=csr_v_pension_provider
267: AND csr_v_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1) AND
268: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
269:
270:
271: rg_le_pp_dtls csr_le_pp_dtls%rowtype;
272: */

Line 370: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));

366: --fnd_file.put_line(fnd_file.log,'Range Code 4');
367: BEGIN
368: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
369: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
370: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
371: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
372: pay_balance_pkg.set_context('SOURCE_ID',NULL);
373: pay_balance_pkg.set_context('TAX_GROUP',NULL);
374: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);

Line 746: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));

742:
743: BEGIN
744: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
745: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
746: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
747: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
748: pay_balance_pkg.set_context('SOURCE_ID',NULL);
749: pay_balance_pkg.set_context('TAX_GROUP',NULL);
750: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);