APPS.PSP_ENC_PRE_PROCESS dependencies on PER_ALL_ASSIGNMENTS_F

Line 152: (select 1 from per_all_assignments_f b

148: -- Code chages for bug 4203036
149: -- To delete all the unwanted records in poeta pre-process
150: delete from psp_enc_changed_assignments a
151: where exists
152: (select 1 from per_all_assignments_f b
153: where b.assignment_id = a.assignment_id
154: and b.effective_end_date = to_date('31-12-4712','DD-MM-RRRR'))
155: and a.chk_asg_end_date_flag = 'Y';
156: -- End of code chages 4203036