DBA Data[Home] [Help]

APPS.OZF_RESALE_WF_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 2354: FROM jtf_rs_resource_extns rsc

2350:
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;

Line 3728: FROM jtf_rs_resource_extns rsc

3724:
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;

Line 3985: FROM jtf_rs_resource_extns rsc

3981:
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;