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

Line 40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))

36: ,p_density OUT NOCOPY NUMBER
37: ) IS
38: --
39: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)

Line 454: AND p_date between fnd_date.canonical_to_date(PAEI.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(PAEI.AEI_INFORMATION2),hr_general.end_of_time);

450: WHERE PAEI.ASSIGNMENT_ID = p_assignment_id
451: AND PAEI.AEI_INFORMATION_CATEGORY = 'NL_PHI'
452: AND ORGANIZATION_ID = PAEI.AEI_INFORMATION3
453: AND ORG_INFORMATION_CONTEXT = 'NL_PHI_ORG_INFO'
454: AND p_date between fnd_date.canonical_to_date(PAEI.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(PAEI.AEI_INFORMATION2),hr_general.end_of_time);
455:
456: -- For Fetching IZA Information
457: cursor csr_get_iza (p_assignment_id number,
458: p_date date) IS

Line 465: AND p_date between fnd_date.canonical_to_date(PAEI.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(PAEI.AEI_INFORMATION2),hr_general.end_of_time);

461: WHERE PAEI.ASSIGNMENT_ID = p_assignment_id
462: AND PAEI.AEI_INFORMATION_CATEGORY = 'NL_IZA_INFO'
463: AND HOI.ORGANIZATION_ID = PAEI.AEI_INFORMATION3
464: AND HOI.ORG_INFORMATION_CONTEXT = 'NL_PHI_ORG_INFO'
465: AND p_date between fnd_date.canonical_to_date(PAEI.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(PAEI.AEI_INFORMATION2),hr_general.end_of_time);
466:
467: l_si_status NUMBER;
468: l_si_provider VARCHAR2(150);
469:

Line 756: and p_rep_date between fnd_date.canonical_to_date(aei.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(aei.AEI_INFORMATION2),hr_general.end_of_time);

752:
753: CURSOR csr_get_cao_code(l_assignment_id NUMBER) IS
754: select AEI_INFORMATION5 from per_assignment_extra_info aei
755: WHERE aei.information_type like 'NL_CADANS_INFO' and aei.assignment_id = l_assignment_id
756: and p_rep_date between fnd_date.canonical_to_date(aei.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(aei.AEI_INFORMATION2),hr_general.end_of_time);
757:
758: l_cao_code VARCHAR2(50);
759:
760: begin