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 1293: FROM pay_element_type_extra_info

1289:
1290: CURSOR c_ele_extra_info ( cp_element_type_id IN NUMBER
1291: ,cp_effective_date DATE ) IS
1292: SELECT 'MX_IDWF' eei_information1
1293: FROM pay_element_type_extra_info
1294: WHERE element_type_id = cp_element_type_id
1295: AND information_type = 'PQP_UK_RATE_TYPE'
1296: AND eei_information_category = 'PQP_UK_RATE_TYPE'
1297: AND ((eei_information1 = 'MX_BASE' AND gv_IDW_calc_method = 'B')

Line 1382: FROM pay_element_type_extra_info

1378: AND cp_end_date;
1379:
1380: CURSOR c_get_infonavit ( cp_element_type_id IN NUMBER ) IS
1381: SELECT eei_information1
1382: FROM pay_element_type_extra_info
1383: WHERE element_type_id = cp_element_type_id
1384: AND information_type = 'MX_DEDUCTION_PROCESSING'
1385: AND eei_information_category = 'MX_DEDUCTION_PROCESSING'
1386: AND eei_information1 = 'INFONAVIT';

Line 3836: FROM pay_element_type_extra_info petei

3832: AND pee.assignment_id = paf.assignment_id + 0
3833: AND cp_effective_date BETWEEN pee.effective_start_date
3834: AND pee.effective_end_date
3835: AND EXISTS ( SELECT 1
3836: FROM pay_element_type_extra_info petei
3837: WHERE petei.information_type = 'MX_DEDUCTION_PROCESSING'
3838: AND petei.eei_information_category =
3839: 'MX_DEDUCTION_PROCESSING'
3840: AND petei.eei_information1 = 'INFONAVIT'