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.PSP_SUM_ADJ dependencies on PAY_ELEMENT_TYPES_F

Line 4459: FROM pay_element_types_f pet1

4455: AND paf2.effective_start_date < trunc(sysdate));
4456:
4457: CURSOR element_name_cur IS
4458: SELECT element_name
4459: FROM pay_element_types_f pet1
4460: WHERE element_type_id = l_element_type_id
4461: AND effective_start_date = (SELECT MAX(effective_start_date)
4462: FROM pay_element_types_f pet2
4463: WHERE pet2.element_type_id = l_element_type_id

Line 4462: FROM pay_element_types_f pet2

4458: SELECT element_name
4459: FROM pay_element_types_f pet1
4460: WHERE element_type_id = l_element_type_id
4461: AND effective_start_date = (SELECT MAX(effective_start_date)
4462: FROM pay_element_types_f pet2
4463: WHERE pet2.element_type_id = l_element_type_id
4464: AND pet2.effective_start_date < trunc(sysdate));
4465:
4466: begin