DBA Data[Home] [Help]

APPS.PJI_PMV_PREDICATE dependencies on FND_PROFILE

Line 39: l_Security_Profile_ID:=fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL');

35: AND papta.project_type= pjicc.class_code
36: AND papta.org_id = p_Org_ID;
37: ELSIF p_Class_Category = '$PROJECT_TYPE$ALL' THEN
38: BEGIN
39: l_Security_Profile_ID:=fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL');
40: SELECT view_all_organizations_flag
41: INTO l_Not_Secured_Flag
42: FROM per_security_profiles prof
43: WHERE security_profile_id = l_Security_Profile_ID;

Line 221: l_Security_Profile_ID:=fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL');

217: l_Return_Value NUMBER;
218: l_Security_Profile_ID NUMBER;
219: l_Not_Secured_Flag VARCHAR2(30);
220: BEGIN
221: l_Security_Profile_ID:=fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL');
222:
223: IF l_Security_Profile_ID IS NOT NULL THEN
224: BEGIN
225: SELECT view_all_organizations_flag