APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 3118: -- Now update for PAY_ELEMENT_ENTRY_VALUES_F

3114: ;
3115:
3116: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');
3117:
3118: -- Now update for PAY_ELEMENT_ENTRY_VALUES_F
3119: UPDATE pay_process_events ppe
3120: SET ppe.retroactive_status = p_status
3121: ,ppe.status = p_status
3122: WHERE ppe.assignment_id = p_assignment_id

Line 3132: WHERE pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

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
3136: )

Line 3138: FROM pay_element_entry_values_f peev

3134: AND peu.change_type = ppe.change_type
3135: AND peu.event_update_id = ppe.event_update_id
3136: )
3137: AND EXISTS (SELECT 1
3138: FROM pay_element_entry_values_f peev
3139: WHERE peev.element_entry_id = p_element_entry_id
3140: AND peev.element_entry_value_id = ppe.surrogate_key
3141: )
3142: ;