DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_PAYROLL_ASSIGNMENT_V

Line 9017: and assignment_id IN(SELECT assignment_id from PSP_ENC_PAYROLL_ASSIGNMENT_V

9013: DELETE FROM psp_enc_changed_assignments
9014: WHERE payroll_action_id = p_payroll_action_id
9015: AND payroll_id = p_payroll_id
9016: AND request_id = l_request_id
9017: and assignment_id IN(SELECT assignment_id from PSP_ENC_PAYROLL_ASSIGNMENT_V
9018: WHERE payroll_id = p_payroll_id
9019: AND exclude = 'Y'
9020: MINUS
9021: SELECT ASSIGNMENT_ID FROM psp_enc_changed_asg_history