DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_EVENT_UPDATES

Line 3108: ,pay_event_updates peu

3104: ,g_effective_run_date)
3105: AND ppe.surrogate_key = p_element_entry_id
3106: AND EXISTS (SELECT 1
3107: FROM pay_dated_tables pdt
3108: ,pay_event_updates peu
3109: WHERE pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
3110: AND peu.dated_table_id = pdt.dated_table_id
3111: AND peu.change_type = ppe.change_type
3112: AND peu.event_update_id = ppe.event_update_id

Line 3131: ,pay_event_updates peu

3127: AND LEAST(NVL(p_end_date,g_effective_run_date)
3128: ,g_effective_run_date)
3129: AND EXISTS (SELECT 1
3130: FROM pay_dated_tables pdt
3131: ,pay_event_updates peu
3132: WHERE pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
3133: AND peu.dated_table_id = pdt.dated_table_id
3134: AND peu.change_type = ppe.change_type
3135: AND peu.event_update_id = ppe.event_update_id

Line 13504: ,pay_event_updates peu

13500: BETWEEN p_start_date AND p_end_date
13501: AND ppe.surrogate_key = p_grade_id
13502: AND EXISTS (SELECT 1
13503: FROM pay_dated_tables pdt
13504: ,pay_event_updates peu
13505: WHERE pdt.table_name = 'PAY_GRADE_RULES_F'
13506: AND peu.dated_table_id = pdt.dated_table_id
13507: AND peu.change_type = ppe.change_type
13508: AND peu.event_update_id = ppe.event_update_id