APPS.OZF_CLAIM_SETTLEMENT_WF_PVT dependencies on PER_PEOPLE_F

Line 29: from jtf_rs_resource_extns rsc , per_people_f ppl

25: IS
26: -- Modified for Bugfix 5199354
27: CURSOR c_resource IS
28: select ppl.person_id source_id
29: from jtf_rs_resource_extns rsc , per_people_f ppl
30: where rsc.category = 'EMPLOYEE' and ppl.person_id = rsc.source_id
31: and trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date
32: and rsc.resource_id = p_user_id;
33: