DBA Data[Home] [Help]

APPS.OZF_RESALE_WF_PVT dependencies on PER_PEOPLE_F

Line 2232: , per_people_f ppl

2228: CURSOR emp_infor_csr(p_res_id NUMBER) IS
2229: -- BUBG 4953233 (+)
2230: SELECT ppl.person_id
2231: FROM jtf_rs_resource_extns rsc
2232: , per_people_f ppl
2233: WHERE rsc.category = 'EMPLOYEE'
2234: AND ppl.person_id = rsc.source_id
2235: AND rsc.resource_id=p_res_id;
2236: -- SELECT employee_id

Line 3517: , per_people_f ppl

3513: CURSOR emp_infor_csr(p_res_id NUMBER) IS
3514: -- BUBG 4953233 (+)
3515: SELECT ppl.person_id
3516: FROM jtf_rs_resource_extns rsc
3517: , per_people_f ppl
3518: WHERE rsc.category = 'EMPLOYEE'
3519: AND ppl.person_id = rsc.source_id
3520: AND rsc.resource_id=p_res_id;
3521: -- SELECT employee_id

Line 3655: , per_people_f ppl

3651: CURSOR emp_infor_csr(p_res_id NUMBER) IS
3652: -- BUBG 4953233 (+)
3653: SELECT ppl.person_id
3654: FROM jtf_rs_resource_extns rsc
3655: , per_people_f ppl
3656: WHERE rsc.category = 'EMPLOYEE'
3657: AND ppl.person_id = rsc.source_id
3658: AND rsc.resource_id=p_res_id;
3659: -- SELECT employee_id