DBA Data[Home] [Help]

APPS.JTF_RESOURCE_UTL dependencies on PER_ALL_PEOPLE_F

Line 1657: FROM per_all_people_f

1653:
1654: CURSOR emp_existence(p_person_id IN NUMBER)
1655: IS
1656: SELECT 'x',full_name
1657: FROM per_all_people_f
1658: WHERE person_id = p_person_id;
1659:
1660: CURSOR c_party_existence(c_party_id IN NUMBER) IS
1661: SELECT hz.party_id

Line 1666: from per_all_people_f per

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