DBA Data[Home] [Help]

APPS.PA_PARCPRJR_XMLP_PKG dependencies on PER_ORGANIZATION_STRUCTURES

Line 177: L_ORG_STR_VERSION_ID PER_ORGANIZATION_STRUCTURES.NAME%TYPE := NULL;

173: RETURN L_SELECTION_OPTION;
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

Line 188: PER_ORGANIZATION_STRUCTURES POS,

184: ,60),
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;