DBA Data[Home] [Help]

APPS.JTF_RESOURCE_UTL dependencies on PER_ALL_PEOPLE_F

Line 1661: FROM per_all_people_f

1657:
1658: CURSOR emp_existence(p_person_id IN NUMBER)
1659: IS
1660: SELECT 'x',full_name
1661: FROM per_all_people_f
1662: WHERE person_id = p_person_id;
1663:
1664: CURSOR c_party_existence(c_party_id IN NUMBER) IS
1665: SELECT hz.party_id

Line 1670: from per_all_people_f per

1666: FROM hz_parties hz
1667: WHERE party_type not in ('ORGANIZATION', 'GROUP')
1668: AND hz.party_id = c_party_id
1669: AND not exists ( select person_id
1670: from per_all_people_f per
1671: where per.party_id = hz.party_id);
1672:
1673: object_code_rec object_code_cur%rowtype;
1674: