[Home] [Help]
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
442: and p_date_earned