DBA Data[Home] [Help]

APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on PER_ALL_PEOPLE_F

Line 3002: per_all_people_f papf

2998:
2999: CURSOR c_party_id IS
3000: select papf.party_id
3001: from jtf_rs_resource_extns jrre,
3002: per_all_people_f papf
3003: where papf.person_id = jrre.source_id
3004: and jrre.resource_id = l_resource_id
3005: and decode(l_resource_type,'RS_EMPLOYEE','EMPLOYEE',null) = jrre.category
3006: and trunc(sysdate) between trunc(papf.effective_start_date) and