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_INPUT_VALUES_F

Line 1128: ,pay_input_values_f piv

1124: FROM pay_process_events ppe
1125: ,pay_event_updates peu
1126: ,pay_dated_tables pdt
1127: ,pay_element_entry_values_f peev
1128: ,pay_input_values_f piv
1129: ,pay_element_types_f pet
1130: WHERE ppe.business_group_id = p_business_group_id
1131: AND ppe.assignment_id = p_assignment_id
1132: AND ppe.change_type = 'DATE_EARNED'

Line 1277: ,pay_input_values_f piv

1273: ,paa.abs_information_category
1274: --,paa.abs_information1 disability_type
1275: ,paa.abs_information2 disability_id
1276: FROM per_absence_attendance_types paat
1277: ,pay_input_values_f piv
1278: ,pay_element_entries_f pee
1279: --,pay_element_entry_values_f peev (Bug 5355325)
1280: ,per_absence_attendances paa
1281: WHERE paat.business_group_id = cp_business_group_id

Line 1325: FROM pay_input_values_f piv

1321: ,pee.assignment_id
1322: ,peev.screen_entry_value
1323: ,pee.effective_start_date
1324: ,pee.effective_end_date
1325: FROM pay_input_values_f piv
1326: ,pay_element_entries_f pee
1327: ,pay_element_entry_values_f peev
1328: WHERE piv.effective_start_date <= cp_end_date
1329: AND piv.effective_end_date >= cp_start_date

Line 1597: FROM pay_input_values_f piv

1593: ,pee.assignment_id
1594: ,peev.screen_entry_value
1595: ,pee.effective_start_date
1596: ,pee.effective_end_date
1597: FROM pay_input_values_f piv
1598: ,pay_element_entries_f pee
1599: ,pay_element_entry_values_f peev
1600: WHERE piv.effective_start_date <= p_end_date
1601: AND piv.effective_end_date >= p_start_date

Line 1642: p_iv_name pay_input_values_f.name%type,

1638: INFONAVIT transactions 18, 19 and 20. */
1639: PROCEDURE load_infonavit_trans (
1640: p_element_entry_id NUMBER,
1641: p_element_type_id NUMBER,
1642: p_iv_name pay_input_values_f.name%type,
1643: p_effective_start_date DATE,
1644: p_effective_end_date DATE,
1645: p_screen_entry_value pay_element_entry_values_f.screen_entry_value%type,
1646: p_tran_type VARCHAR2) IS

Line 1660: FROM pay_input_values_f piv

1656: ,pee.assignment_id
1657: ,peev.screen_entry_value
1658: ,pee.effective_start_date
1659: ,pee.effective_end_date
1660: FROM pay_input_values_f piv
1661: ,pay_element_entries_f pee
1662: ,pay_element_entry_values_f peev
1663: WHERE piv.effective_start_date <= cp_end_date
1664: AND piv.effective_end_date >= cp_start_date

Line 3636: ,pay_input_values_f piv

3632: ,cp_element_entry_id NUMBER
3633: ,cp_effective_date DATE ) IS
3634: SELECT piv.name, peev.screen_entry_value
3635: FROM pay_element_entry_values_f peev
3636: ,pay_input_values_f piv
3637: WHERE piv.element_type_id = cp_element_type_id
3638: AND peev.element_entry_id = cp_element_entry_id
3639: AND piv.input_value_id = peev.input_value_id
3640: AND cp_effective_date BETWEEN piv.effective_start_date