DBA Data[Home] [Help]

APPS.JA_JAINITCR_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 203: HR_ORGANIZATION_UNITS

199: CURSOR ORG_NAME_CUR(P_ORGANIZATION_ID IN NUMBER) IS
200: SELECT
201: NAME
202: FROM
203: HR_ORGANIZATION_UNITS
204: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
205: V_NAME1 VARCHAR(60);
206: BEGIN
207: OPEN ORG_NAME_CUR(P_ORGANIZATION_ID);

Line 224: HR_ORGANIZATION_UNITS HOU,

220: ,HOU.INTERNAL_ADDRESS_LINE
221: ,LOC.ADDRESS_LINE_1 || ',' || LOC.ADDRESS_LINE_2 || ',' || LOC.ADDRESS_LINE_3 || ',' || LOC.TOWN_OR_CITY || ',' || LOC.POSTAL_CODE || ',' || LOC.COUNTRY)
222: INTO V_ADDRESS1
223: FROM
224: HR_ORGANIZATION_UNITS HOU,
225: HR_LOCATIONS LOC
226: WHERE HOU.ORGANIZATION_ID = P_ORGANIZATION_ID
227: AND HOU.LOCATION_ID = loc.location_id (+);
228: RETURN (V_ADDRESS1);