APPS.PV_PARTNER_PROGRAM_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 1033: FROM jtf_rs_resource_extns

1029: WHERE PROGRAM_ID = l_id;
1030:
1031: CURSOR c_resource_id(p_user_id IN NUMBER) IS
1032: SELECT RESOURCE_ID
1033: FROM jtf_rs_resource_extns
1034: WHERE USER_ID=p_user_id;
1035:
1036: BEGIN
1037: ---------------Initialize --------------------

Line 2914: FROM JTF_RS_RESOURCE_EXTNS

2910: IS
2911:
2912: CURSOR c_resource_exists IS
2913: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1
2914: FROM JTF_RS_RESOURCE_EXTNS
2915: WHERE RESOURCE_ID = p_ptr_prgm_rec.program_owner_resource_id
2916: AND NVL(end_date_active,SYSDATE) >= SYSDATE AND NVL(start_date_active, SYSDATE) <= SYSDATE);
2917:
2918: l_process_type VARCHAR2(4000) := 'PARTNER_PROGRAM';

Line 4064: FROM jtf_rs_resource_extns res

4060: AND enabled_flag = 'Y';
4061:
4062: CURSOR C_get_current_resource IS
4063: SELECT res.resource_id resource_id
4064: FROM jtf_rs_resource_extns res
4065: WHERE res.category IN ('EMPLOYEE', 'PARTY')
4066: AND res.user_id = fnd_global.user_id;
4067:
4068: l_src_ptr_pgrm_rec c_get_ptr_prgm_rec%ROWTYPE;

Line 5584: FROM jtf_rs_resource_extns

5580: WHERE PROGRAM_ID = p_id;
5581:
5582: CURSOR c_resource_id(p_user_id IN NUMBER) IS
5583: SELECT RESOURCE_ID
5584: FROM jtf_rs_resource_extns
5585: WHERE USER_ID=p_user_id;
5586:
5587:
5588: BEGIN