APPS.PV_PRGM_APPROVAL_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 838: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL

834:
835:
836: CURSOR c_program_rec (p_program_id IN NUMBER) IS
837: SELECT PROGRAM_NAME,MEANING,PROGRAM_START_DATE,PROGRAM_END_DATE,SOURCE_NAME,PROGRAM_DESCRIPTION,SOURCE_BUSINESS_GRP_NAME
838: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL
839: WHERE PROGRAM_ID =p_program_id
840: AND PROGRAM_OWNER_RESOURCE_ID =RESOURCE_ID
841: AND LOOKUP_CODE=PROGRAM_LEVEL_CODE
842: AND LOOKUP_TYPE='PV_PROGRAM_LEVEL';

Line 983: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL

979:
980:
981: CURSOR c_program_rec (p_program_id IN NUMBER) IS
982: SELECT PROGRAM_NAME,MEANING,PROGRAM_START_DATE,PROGRAM_END_DATE,SOURCE_NAME,PROGRAM_DESCRIPTION,SOURCE_BUSINESS_GRP_NAME
983: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL
984: WHERE PROGRAM_ID =p_program_id
985: AND PROGRAM_OWNER_RESOURCE_ID =RESOURCE_ID
986: AND LOOKUP_CODE=PROGRAM_LEVEL_CODE
987: AND LOOKUP_TYPE='PV_PROGRAM_LEVEL';

Line 1140: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL

1136:
1137:
1138: CURSOR c_program_rec (p_program_id IN NUMBER) IS
1139: SELECT PROGRAM_NAME,MEANING,PROGRAM_START_DATE,PROGRAM_END_DATE,SOURCE_NAME,PROGRAM_DESCRIPTION,SOURCE_BUSINESS_GRP_NAME
1140: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL
1141: WHERE PROGRAM_ID =p_program_id
1142: AND PROGRAM_OWNER_RESOURCE_ID =RESOURCE_ID
1143: AND LOOKUP_CODE=PROGRAM_LEVEL_CODE
1144: AND LOOKUP_TYPE='PV_PROGRAM_LEVEL';

Line 1297: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL

1293: l_url2 VARCHAR2 (360);
1294:
1295: CURSOR c_program_rec (p_program_id IN NUMBER) IS
1296: SELECT PROGRAM_NAME,MEANING,PROGRAM_START_DATE,PROGRAM_END_DATE,SOURCE_NAME,PROGRAM_DESCRIPTION,SOURCE_BUSINESS_GRP_NAME
1297: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL
1298: WHERE PROGRAM_ID =p_program_id
1299: AND PROGRAM_OWNER_RESOURCE_ID =RESOURCE_ID
1300: AND LOOKUP_CODE=PROGRAM_LEVEL_CODE
1301: AND LOOKUP_TYPE='PV_PROGRAM_LEVEL';

Line 1446: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL

1442: l_url2 VARCHAR2 (360);
1443:
1444: CURSOR c_program_rec (p_program_id IN NUMBER) IS
1445: SELECT PROGRAM_NAME,MEANING,PROGRAM_START_DATE,PROGRAM_END_DATE,SOURCE_NAME,PROGRAM_DESCRIPTION,SOURCE_BUSINESS_GRP_NAME
1446: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL
1447: WHERE PROGRAM_ID =p_program_id
1448: AND PROGRAM_OWNER_RESOURCE_ID =RESOURCE_ID
1449: AND LOOKUP_CODE=PROGRAM_LEVEL_CODE
1450: AND LOOKUP_TYPE='PV_PROGRAM_LEVEL';

Line 3226: FROM jtf_rs_resource_extns_vl res,fnd_user fnd

3222: AND arc_appr_for_entity_code='ENRQ';
3223:
3224: CURSOR c_resource_per_cur(p_appr_id NUMBER) IS
3225: SELECT res.resource_id,res.resource_name
3226: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
3227: WHERE fnd.employee_id = p_appr_id
3228: AND res.user_id=fnd.user_id;
3229:
3230: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS

Line 3232: FROM jtf_rs_resource_extns_vl res,fnd_user fnd

3228: AND res.user_id=fnd.user_id;
3229:
3230: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS
3231: SELECT res.resource_id,res.resource_name
3232: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
3233: WHERE fnd.user_id = p_appr_id
3234: AND res.user_id=fnd.user_id;
3235:
3236: CURSOR c_enrl_cur ( enrl_id NUMBER ) IS

Line 3257: , jtf_rs_resource_extns_vl res

3253:
3254: CURSOR is_partner_usr_csr( p_usr_id NUMBER ) IS
3255: SELECT 'Y'
3256: FROM fnd_user usr
3257: , jtf_rs_resource_extns_vl res
3258: WHERE usr.user_id=p_usr_id
3259: AND usr.user_id=res.user_id
3260: AND res.category='PARTY';
3261:

Line 4115: FROM jtf_rs_resource_extns_vl res,fnd_user fnd

4111: WHERE enrl_request_id=p_enrl_req_id;
4112:
4113: CURSOR c_resource_per_cur(p_appr_id NUMBER) IS
4114: SELECT res.resource_id,res.resource_name
4115: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
4116: WHERE fnd.employee_id = p_appr_id
4117: AND res.user_id=fnd.user_id;
4118:
4119: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS

Line 4121: FROM jtf_rs_resource_extns_vl res,fnd_user fnd

4117: AND res.user_id=fnd.user_id;
4118:
4119: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS
4120: SELECT res.resource_id,res.resource_name
4121: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
4122: WHERE fnd.user_id = p_appr_id
4123: AND res.user_id=fnd.user_id;
4124:
4125: CURSOR person_id_csr ( p_user_id NUMBER ) IS