APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 3090: -- Now update for PAY_ELEMENT_ENTRY_VALUES_F

3086: ;
3087:
3088: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');
3089:
3090: -- Now update for PAY_ELEMENT_ENTRY_VALUES_F
3091: UPDATE pay_process_events ppe
3092: SET ppe.retroactive_status = p_status
3093: ,ppe.status = p_status
3094: WHERE ppe.assignment_id = p_assignment_id

Line 3104: WHERE pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

3100: ,g_effective_run_date)
3101: AND EXISTS (SELECT 1
3102: FROM pay_dated_tables pdt
3103: ,pay_event_updates peu
3104: WHERE pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
3105: AND peu.dated_table_id = pdt.dated_table_id
3106: AND peu.change_type = ppe.change_type
3107: AND peu.event_update_id = ppe.event_update_id
3108: )

Line 3110: FROM pay_element_entry_values_f peev

3106: AND peu.change_type = ppe.change_type
3107: AND peu.event_update_id = ppe.event_update_id
3108: )
3109: AND EXISTS (SELECT 1
3110: FROM pay_element_entry_values_f peev
3111: WHERE peev.element_entry_id = p_element_entry_id
3112: AND peev.element_entry_value_id = ppe.surrogate_key
3113: )
3114: ;