APPS.PA_PARCPRJR_XMLP_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 178: L_ORG_STR_VERSION_NUM PER_ORG_STRUCTURE_VERSIONS.VERSION_NUMBER%TYPE := NULL;

174: END CF_SELECTION_OPTIONFORMULA;
175:
176: FUNCTION CF_ORG_STR_VERSION_IDFORMULA RETURN CHAR IS
177: L_ORG_STR_VERSION_ID PER_ORGANIZATION_STRUCTURES.NAME%TYPE := NULL;
178: L_ORG_STR_VERSION_NUM PER_ORG_STRUCTURE_VERSIONS.VERSION_NUMBER%TYPE := NULL;
179: BEGIN
180: IF P_ORG_STR_VERSION_ID IS NOT NULL THEN
181: SELECT
182: SUBSTR(POS.NAME

Line 189: PER_ORG_STRUCTURE_VERSIONS POSV

185: POSV.VERSION_NUMBER
186: INTO L_ORG_STR_VERSION_ID,L_ORG_STR_VERSION_NUM
187: FROM
188: PER_ORGANIZATION_STRUCTURES POS,
189: PER_ORG_STRUCTURE_VERSIONS POSV
190: WHERE POSV.ORGANIZATION_STRUCTURE_ID = POS.ORGANIZATION_STRUCTURE_ID
191: AND POSV.ORG_STRUCTURE_VERSION_ID = P_ORG_STR_VERSION_ID;
192: END IF;
193: IF P_ORG_STR_VERSION_ID IS NOT NULL THEN