APPS.PA_PARCPRJR_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 201: L_START_ORG_ID HR_ORGANIZATION_UNITS.NAME%TYPE := NULL;

197: END IF;
198: END CF_ORG_STR_VERSION_IDFORMULA;
199:
200: FUNCTION CF_START_ORG_IDFORMULA RETURN CHAR IS
201: L_START_ORG_ID HR_ORGANIZATION_UNITS.NAME%TYPE := NULL;
202: BEGIN
203: IF P_START_ORGANIZATION_ID IS NOT NULL THEN
204: SELECT
205: SUBSTR(NAME

Line 210: HR_ORGANIZATION_UNITS

206: ,1
207: ,60)
208: INTO L_START_ORG_ID
209: FROM
210: HR_ORGANIZATION_UNITS
211: WHERE ORGANIZATION_ID = P_START_ORGANIZATION_ID;
212: END IF;
213: RETURN L_START_ORG_ID;
214: END CF_START_ORG_IDFORMULA;