DBA Data[Home] [Help]

APPS.PJI_PMV_PREDICATE dependencies on PA_IMPLEMENTATIONS_ALL

Line 51: , pa_implementations_all paimp

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'
55: AND papta.project_type= pjicc.class_code

Line 63: , pa_implementations_all paimp

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
66: AND pjicc.record_type = 'T'
67: AND papta.project_type= pjicc.class_code

Line 106: pa_implementations_all paimp

102: BEGIN
103: SELECT 1
104: INTO l_Return_Value
105: FROM
106: pa_implementations_all paimp
107: , gl_sets_of_books glsob
108: WHERE
109: paimp.set_of_books_id = glsob.set_of_books_id
110: and paimp.org_id = p_Org_ID

Line 232: FROM pa_implementations_all imp

228: WHERE security_profile_id = l_Security_Profile_ID;
229: IF l_Not_Secured_Flag = 'Y' THEN
230: SELECT 1
231: INTO l_Return_Value
232: FROM pa_implementations_all imp
233: WHERE org_id = p_Org_ID;
234: ELSE
235: SELECT 1
236: INTO l_Return_Value

Line 238: pa_implementations_all imp

234: ELSE
235: SELECT 1
236: INTO l_Return_Value
237: FROM
238: pa_implementations_all imp
239: , per_organization_list list
240: WHERE
241: list.security_profile_id = l_Security_Profile_ID
242: AND list.organization_id = p_Org_ID