APPS.PAY_AE_ELEMENT_TEMPLATE_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 252: FROM per_contact_relationships pcr

248: AND p_date_earned BETWEEN ppl.effective_start_date AND ppl.effective_end_date;
249:
250: CURSOR csr_get_dependent_children IS
251: SELECT COUNT(DISTINCT contact_person_id)
252: FROM per_contact_relationships pcr
253: ,per_all_assignments_f asg
254: WHERE asg.person_id = pcr.person_id
255: AND asg.assignment_id = p_assignment_id
256: AND pcr.contact_type = 'C'