DBA Data[Home] [Help]

APPS.PAY_FR_PTO_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 3825: ,per_contact_relationships pcr

3821: CURSOR csr_count is
3822: select count(distinct(d.person_id))
3823: from per_all_people_f d
3824: ,per_all_people_f p
3825: ,per_contact_relationships pcr
3826: ,per_all_assignments_f asg
3827: where asg.assignment_id = P_assignment_id
3828: and asg.business_group_id = p_business_Group_id
3829: and asg.person_id = p.person_id