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.PER_JP_EMPDET_REPORT_PKG dependencies on FND_DATE

Line 1435: AND p_effective_date BETWEEN FND_DATE.canonical_to_date(HOI.org_information5)

1431: WHERE HOI.org_information_context = 'JP_REPORTS_ADDITIONAL_INFO'
1432: AND HOI.org_information1 = 'JPEMPLDETAILSREPORT'
1433: AND HOI.organization_id = p_business_group_id
1434: AND HOI.org_information3 = p_info_type
1435: AND p_effective_date BETWEEN FND_DATE.canonical_to_date(HOI.org_information5)
1436: AND FND_DATE.canonical_to_date(HOI.org_information6);
1437: --
1438: CURSOR lcu_emp_add_info(p_mag_asg_action_id NUMBER)
1439: IS

Line 1436: AND FND_DATE.canonical_to_date(HOI.org_information6);

1432: AND HOI.org_information1 = 'JPEMPLDETAILSREPORT'
1433: AND HOI.organization_id = p_business_group_id
1434: AND HOI.org_information3 = p_info_type
1435: AND p_effective_date BETWEEN FND_DATE.canonical_to_date(HOI.org_information5)
1436: AND FND_DATE.canonical_to_date(HOI.org_information6);
1437: --
1438: CURSOR lcu_emp_add_info(p_mag_asg_action_id NUMBER)
1439: IS
1440: SELECT PJEDAI.additional_information1