APPS.PAY_FR_COURT_ORDERS dependencies on PER_ALL_ASSIGNMENTS_F

Line 437: , per_all_assignments_f a

433: /* BUG 2481752 Cursor updated to reflect a fix by the PHQ team */
434: Cursor csr_no_of_dpndts is
435: select count(*)
436: from PER_CONTACT_RELATIONSHIPS PCR
437: , per_all_assignments_f a
438: , pay_assignment_actions aa
439: where PCR.person_id = a.person_id
440: and a.assignment_id = aa.assignment_id
441: and aa.assignment_action_id = p_assignment_action_id