DBA Data[Home] [Help]

APPS.PA_PAXBUBSS_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 14: P_ORG HR_ORGANIZATION_UNITS.NAME%TYPE;

10: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
11: BEGIN
12: DECLARE
13: INIT_FAILURE EXCEPTION;
14: P_ORG HR_ORGANIZATION_UNITS.NAME%TYPE;
15: P_MGR VARCHAR2(30);
16: P_NUMBER VARCHAR2(30);
17: P_NAME VARCHAR2(30);
18: TSK_NUM VARCHAR2(30);

Line 40: HR_ORGANIZATION_UNITS

36: ,1
37: ,60)
38: INTO P_ORG
39: FROM
40: HR_ORGANIZATION_UNITS
41: WHERE ORG = ORGANIZATION_ID;
42: END IF;
43: C_ORG := P_ORG;
44: IF MGR IS NOT NULL THEN