DBA Data[Home] [Help]

APPS.PAY_FR_COURT_ORDERS dependencies on PER_CONTACT_RELATIONSHIPS

Line 436: from PER_CONTACT_RELATIONSHIPS PCR

432: /* BUG 2245520 Changed cursor to reflect PQH dynamic dependant calc */
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