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_MX_SOC_SEC_ARCHIVE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 1218: FROM pay_element_type_extra_info

1214:
1215: CURSOR c_ele_extra_info ( cp_element_type_id IN NUMBER
1216: ,cp_effective_date DATE ) IS
1217: SELECT 'MX_IDWF' eei_information1
1218: FROM pay_element_type_extra_info
1219: WHERE element_type_id = cp_element_type_id
1220: AND information_type = 'PQP_UK_RATE_TYPE'
1221: AND eei_information_category = 'PQP_UK_RATE_TYPE'
1222: AND ((eei_information1 = 'MX_BASE' AND gv_IDW_calc_method = 'B')

Line 1307: FROM pay_element_type_extra_info

1303: AND cp_end_date;
1304:
1305: CURSOR c_get_infonavit ( cp_element_type_id IN NUMBER ) IS
1306: SELECT eei_information1
1307: FROM pay_element_type_extra_info
1308: WHERE element_type_id = cp_element_type_id
1309: AND information_type = 'MX_DEDUCTION_PROCESSING'
1310: AND eei_information_category = 'MX_DEDUCTION_PROCESSING'
1311: AND eei_information1 = 'INFONAVIT';

Line 3623: FROM pay_element_type_extra_info petei

3619: AND pee.assignment_id = paf.assignment_id + 0
3620: AND cp_effective_date BETWEEN pee.effective_start_date
3621: AND pee.effective_end_date
3622: AND EXISTS ( SELECT 1
3623: FROM pay_element_type_extra_info petei
3624: WHERE petei.information_type = 'MX_DEDUCTION_PROCESSING'
3625: AND petei.eei_information_category =
3626: 'MX_DEDUCTION_PROCESSING'
3627: AND petei.eei_information1 = 'INFONAVIT'