APPS.JA_JAINARE1_XMLP_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 20: ORG_ORGANIZATION_DEFINITIONS

16: CURSOR C_ORGANIZATION(P_ORGANIZATION_ID IN NUMBER) IS
17: SELECT
18: LEGAL_ENTITY
19: FROM
20: ORG_ORGANIZATION_DEFINITIONS
21: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
22: V_ORGANIZATION_ID ORG_ORGANIZATION_DEFINITIONS.LEGAL_ENTITY%TYPE;
23: V_LOCATION_ID HR_ORGANIZATION_UNITS.LOCATION_ID%TYPE;
24: V_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;

Line 22: V_ORGANIZATION_ID ORG_ORGANIZATION_DEFINITIONS.LEGAL_ENTITY%TYPE;

18: LEGAL_ENTITY
19: FROM
20: ORG_ORGANIZATION_DEFINITIONS
21: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
22: V_ORGANIZATION_ID ORG_ORGANIZATION_DEFINITIONS.LEGAL_ENTITY%TYPE;
23: V_LOCATION_ID HR_ORGANIZATION_UNITS.LOCATION_ID%TYPE;
24: V_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
25: BEGIN
26: OPEN C_ORGANIZATION(P_ORGANIZATION_ID);

Line 52: ORG_ORGANIZATION_DEFINITIONS

48: CURSOR C_LEGAL_ENTITY_ID(P_ORGANIZATION_ID IN NUMBER) IS
49: SELECT
50: LEGAL_ENTITY
51: FROM
52: ORG_ORGANIZATION_DEFINITIONS
53: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
54: V_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
55: V_LEGAL_ENTITY_ID ORG_ORGANIZATION_DEFINITIONS.LEGAL_ENTITY%TYPE;
56: BEGIN

Line 54: V_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;

50: LEGAL_ENTITY
51: FROM
52: ORG_ORGANIZATION_DEFINITIONS
53: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
54: V_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
55: V_LEGAL_ENTITY_ID ORG_ORGANIZATION_DEFINITIONS.LEGAL_ENTITY%TYPE;
56: BEGIN
57: OPEN C_LEGAL_ENTITY_ID(P_ORGANIZATION_ID);
58: FETCH C_LEGAL_ENTITY_ID

Line 55: V_LEGAL_ENTITY_ID ORG_ORGANIZATION_DEFINITIONS.LEGAL_ENTITY%TYPE;

51: FROM
52: ORG_ORGANIZATION_DEFINITIONS
53: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
54: V_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
55: V_LEGAL_ENTITY_ID ORG_ORGANIZATION_DEFINITIONS.LEGAL_ENTITY%TYPE;
56: BEGIN
57: OPEN C_LEGAL_ENTITY_ID(P_ORGANIZATION_ID);
58: FETCH C_LEGAL_ENTITY_ID
59: INTO V_LEGAL_ENTITY_ID;

Line 222: ORG_ORGANIZATION_DEFINITIONS

218: CURSOR C_SET_OF_BOOKS(P_OPERATING_UNIT_ID IN NUMBER) IS
219: SELECT
220: SET_OF_BOOKS_ID
221: FROM
222: ORG_ORGANIZATION_DEFINITIONS
223: WHERE ORGANIZATION_ID = P_OPERATING_UNIT_ID;
224: V_SOB NUMBER;
225: BEGIN
226: OPEN C_SET_OF_BOOKS(P_ORGANIZATION_ID);