DBA Data[Home] [Help]

APPS.OZF_RESALE_WF_PVT dependencies on PER_PEOPLE_F

Line 2355: , per_people_f ppl

2351: CURSOR emp_infor_csr(p_res_id NUMBER) IS
2352: -- BUBG 4953233 (+)
2353: SELECT ppl.person_id
2354: FROM jtf_rs_resource_extns rsc
2355: , per_people_f ppl
2356: WHERE rsc.category = 'EMPLOYEE'
2357: AND ppl.person_id = rsc.source_id
2358: AND rsc.resource_id=p_res_id;
2359: -- SELECT employee_id

Line 3729: , per_people_f ppl

3725: CURSOR emp_infor_csr(p_res_id NUMBER) IS
3726: -- BUBG 4953233 (+)
3727: SELECT ppl.person_id
3728: FROM jtf_rs_resource_extns rsc
3729: , per_people_f ppl
3730: WHERE rsc.category = 'EMPLOYEE'
3731: AND ppl.person_id = rsc.source_id
3732: AND rsc.resource_id=p_res_id;
3733: -- SELECT employee_id

Line 3986: , per_people_f ppl

3982: CURSOR emp_infor_csr(p_res_id NUMBER) IS
3983: -- BUBG 4953233 (+)
3984: SELECT ppl.person_id
3985: FROM jtf_rs_resource_extns rsc
3986: , per_people_f ppl
3987: WHERE rsc.category = 'EMPLOYEE'
3988: AND ppl.person_id = rsc.source_id
3989: AND rsc.resource_id=p_res_id;
3990: -- SELECT employee_id