DBA Data[Home] [Help]

APPS.PER_PERRPRTM_XMLP_PKG dependencies on FND_GLOBAL

Line 94: L_PROFILE_ID := FND_GLOBAL.PER_SECURITY_PROFILE_ID;

90: P_ORG_MATCHING := ' where p.organization_id in ( select organization_id_child ' || ' from per_org_structure_elements ' || ' where org_structure_version_id = ' ||
91: TO_CHAR(P_ORG_STRUCTURE_VERSION_ID) || ' union ' || ' select distinct organization_id_parent ' ||
92: ' from per_org_structure_elements ' || ' where org_structure_version_id = ' || TO_CHAR(P_ORG_STRUCTURE_VERSION_ID) || ')';
93: ELSE
94: L_PROFILE_ID := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
95: OPEN CSR_VIEW_ALL_FLAG(L_PROFILE_ID);
96: FETCH CSR_VIEW_ALL_FLAG
97: INTO L_VIEW_ALL_FLAG;
98: CLOSE CSR_VIEW_ALL_FLAG;