APPS.AMS_WFCMPAPR_PVT dependencies on AMS_JTF_RS_EMP_V

Line 425: FROM ams_jtf_rs_emp_v

421: -- Following code is modified by ptendulk on 07-Jun-2000
422: -- the view is changed to faster jtf view
423: CURSOR c_get_person(l_res_id NUMBER) IS
424: SELECT employee_id source_id
425: FROM ams_jtf_rs_emp_v
426: WHERE resource_id = l_res_id ;
427:
428: l_person_id NUMBER ;
429:

Line 510: FROM ams_jtf_rs_emp_v

506: )
507: IS
508: CURSOR c_user_det IS
509: SELECT manager_id,employee_id
510: FROM ams_jtf_rs_emp_v
511: WHERE resource_id = p_user_id ;
512:
513: -- Write cirsor to get Manager's Resource ID
514:

Line 688: FROM ams_jtf_rs_emp_v

684: -- Following code is modified by ptendulk on 07-Jun-00
685: -- Replaced JTF view with the faster one
686: CURSOR c_get_person(l_res_id NUMBER) IS
687: SELECT employee_id source_id
688: FROM ams_jtf_rs_emp_v
689: WHERE resource_id = l_res_id ;
690:
691: l_person_id NUMBER;
692: l_resource_id NUMBER;

Line 831: FROM ams_jtf_rs_emp_v

827: -- Following code is modified by ptendulk on 07-Jun-00
828: -- Replaced JTF view with the faster one
829: CURSOR c_resource IS
830: SELECT resource_id ,employee_id source_id
831: FROM ams_jtf_rs_emp_v
832: WHERE user_id = p_requester_userid ;
833: l_requester_id NUMBER ;
834: l_person_id NUMBER ;
835:

Line 1451: FROM ams_jtf_rs_emp_v

1447:
1448: -- *************************8Need to Change
1449: CURSOR c_emp_id(l_usr VARCHAR2) IS
1450: SELECT resource_id
1451: FROM ams_jtf_rs_emp_v
1452: WHERE resource_id = 100 ;
1453:
1454: BEGIN
1455: -- Note API to Update Approval Notes

Line 3036: FROM ams_jtf_rs_emp_v jtf,ams_campaigns_vl camp

3032: -- on 08-Jun-2000
3033: CURSOR c_camp_owner(l_id NUMBER)
3034: IS
3035: SELECT jtf.full_name
3036: FROM ams_jtf_rs_emp_v jtf,ams_campaigns_vl camp
3037: WHERE camp.campaign_id = l_id
3038: AND jtf.resource_id = camp.owner_user_id ;
3039:
3040: CURSOR c_eveh_owner(l_id NUMBER)

Line 3043: FROM ams_jtf_rs_emp_v jtf,ams_event_headers_vl eveh

3039:
3040: CURSOR c_eveh_owner(l_id NUMBER)
3041: IS
3042: SELECT jtf.full_name
3043: FROM ams_jtf_rs_emp_v jtf,ams_event_headers_vl eveh
3044: WHERE eveh.event_header_id = l_id
3045: AND jtf.resource_id = eveh.owner_user_id ;
3046:
3047: CURSOR c_eveo_owner(l_id NUMBER)

Line 3050: FROM ams_jtf_rs_emp_v jtf,ams_event_offers_vl eveo

3046:
3047: CURSOR c_eveo_owner(l_id NUMBER)
3048: IS
3049: SELECT jtf.full_name
3050: FROM ams_jtf_rs_emp_v jtf,ams_event_offers_vl eveo
3051: WHERE eveo.event_offer_id = l_id
3052: AND jtf.resource_id = eveo.owner_user_id ;
3053:
3054: