APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on PER_ALL_PEOPLE_F
Line 2495: per_all_people_f papf
2491:
2492: CURSOR c_party_id IS
2493: select papf.party_id
2494: from jtf_rs_resource_extns jrre, 2495: per_all_people_f papf 2496: where papf.person_id = jrre.source_id
2497: and jrre.resource_id = l_resource_id
2498: and trunc(sysdate) between trunc(papf.effective_start_date) and
2499: trunc(papf.effective_end_date)