APPS.PJI_PMV_PREDICATE dependencies on PA_PROJECT_TYPES_ALL

Line 19: , pa_project_types_all papta

15: IF p_Class_Category = '$PROJECT_TYPE$ALL' AND (UPPER(p_Org_ID) <> 'ALL' AND p_Org_ID IS NOT NULL) THEN
16: SELECT 1
17: INTO l_Return_Value
18: FROM pji_class_codes pjicc
19: , pa_project_types_all papta
20: WHERE
21: pjicc.class_id = p_Class_Code
22: AND pjicc.record_type = 'T'
23: AND papta.project_type= pjicc.class_code

Line 29: , pa_project_types_all papta

25: ELSIF SUBSTR(p_Class_Category, 1, 14) = '$PROJECT_TYPE$' AND (UPPER(p_Org_ID) <> 'ALL' AND p_Org_ID IS NOT NULL) THEN
26: SELECT 1
27: INTO l_Return_Value
28: FROM pji_class_codes pjicc
29: , pa_project_types_all papta
30: WHERE
31: pjicc.class_id = p_Class_Code
32: AND pjicc.class_category = p_Class_Category
33: AND pjicc.record_type = 'T'

Line 50: , pa_project_types_all papta

46: IF l_Not_Secured_Flag = 'Y' THEN
47: SELECT 1
48: INTO l_Return_Value
49: FROM pji_class_codes pjicc
50: , pa_project_types_all papta
51: , pa_implementations_all paimp
52: WHERE
53: pjicc.class_id = p_Class_Code
54: AND pjicc.record_type = 'T'

Line 61: , pa_project_types_all papta

57: ELSE
58: SELECT 1
59: INTO l_Return_Value
60: FROM pji_class_codes pjicc
61: , pa_project_types_all papta
62: , per_organization_list sec
63: , pa_implementations_all paimp
64: WHERE
65: pjicc.class_id = p_Class_Code