DBA Data[Home] [Help]

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)