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 4890: FROM pay_element_types_f pet1

4886: AND paf2.effective_start_date < trunc(sysdate));
4887:
4888: CURSOR element_name_cur IS
4889: SELECT element_name
4890: FROM pay_element_types_f pet1
4891: WHERE element_type_id = l_element_type_id
4892: AND effective_start_date = (SELECT MAX(effective_start_date)
4893: FROM pay_element_types_f pet2
4894: WHERE pet2.element_type_id = l_element_type_id

Line 4893: FROM pay_element_types_f pet2

4889: SELECT element_name
4890: FROM pay_element_types_f pet1
4891: WHERE element_type_id = l_element_type_id
4892: AND effective_start_date = (SELECT MAX(effective_start_date)
4893: FROM pay_element_types_f pet2
4894: WHERE pet2.element_type_id = l_element_type_id
4895: AND pet2.effective_start_date < trunc(sysdate));
4896:
4897: begin