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_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_LINKS_F

Line 1056: from pay_element_links_f pel

1052: pel.QUALIFYING_LENGTH_OF_SERVICE,
1053: pel.QUALIFYING_UNITS,
1054: greatest(pel.EFFECTIVE_START_DATE, to_date('2005/07/01','YYYY/MM/DD')) EFFECTIVE_START_DATE /* 5731490 */
1055: ,pel.EFFECTIVE_END_DATE
1056: from pay_element_links_f pel
1057: where pel.element_type_id = c_element_type_id
1058: and pel.business_group_id = p_business_group_id
1059: and pel.effective_start_date = (
1060: select max(pel.effective_start_date)

Line 1061: from pay_element_links_f pel1

1057: where pel.element_type_id = c_element_type_id
1058: and pel.business_group_id = p_business_group_id
1059: and pel.effective_start_date = (
1060: select max(pel.effective_start_date)
1061: from pay_element_links_f pel1
1062: where pel.element_link_id=pel1.element_link_id
1063: ) /* 5731490 */
1064: and ( p_effective_date between pel.effective_start_date and pel.effective_end_date
1065: or pel.effective_start_date > p_effective_date) /* 5731490 */