APPS.PV_PRGM_APPROVAL_PVT dependencies on FND_LOOKUP_VALUES_VL

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';