APPS.JA_JAINITCP_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 48: HR_ORGANIZATION_UNITS HOU,

44: INTO P_FROM_DATE_T
45: FROM
46: JAI_AP_TDS_F16_HDRS_ALL AFRM,
47: JAI_AP_TDS_F16_DTLS_ALL FRMD,
48: HR_ORGANIZATION_UNITS HOU,
49: HR_LOCATIONS LOC,
50: JAI_CMN_INVENTORY_ORGS JHOU,
51: AP_INVOICES_ALL API1,
52: AP_INVOICES_ALL API2,

Line 116: HR_ORGANIZATION_UNITS

112: CURSOR ORG_NAME_CUR(CP_ORGANIZATION_ID IN NUMBER) IS
113: SELECT
114: NAME
115: FROM
116: HR_ORGANIZATION_UNITS
117: WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID;
118: CURSOR INTERNAL_ADD_CUR(CP_ORGANIZATION_ID IN NUMBER) IS
119: SELECT
120: NVL(INTERNAL_ADDRESS_LINE

Line 123: HR_ORGANIZATION_UNITS

119: SELECT
120: NVL(INTERNAL_ADDRESS_LINE
121: ,'NIL')
122: FROM
123: HR_ORGANIZATION_UNITS
124: WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID;
125: CURSOR TOWN_OR_CITY_CUR(CP_ORGANIZATION_ID IN NUMBER) IS
126: SELECT
127: NVL(LOC.TOWN_OR_CITY

Line 132: HR_ORGANIZATION_UNITS HR

128: ,'NIL') || '-' || NVL(LOC.POSTAL_CODE
129: ,'NIL')
130: FROM
131: HR_LOCATIONS LOC,
132: HR_ORGANIZATION_UNITS HR
133: WHERE LOC.LOCATION_ID = HR.LOCATION_ID
134: AND HR.ORGANIZATION_ID = CP_ORGANIZATION_ID;
135: CURSOR COUNTRY_CUR(CP_ORGANIZATION_ID IN NUMBER) IS
136: SELECT

Line 141: HR_ORGANIZATION_UNITS HR

137: NVL(LOC.COUNTRY
138: ,'NIL')
139: FROM
140: HR_LOCATIONS LOC,
141: HR_ORGANIZATION_UNITS HR
142: WHERE LOC.LOCATION_ID = HR.LOCATION_ID
143: AND HR.ORGANIZATION_ID = CP_ORGANIZATION_ID;
144: CURSOR PO_VENDOR_NAME_CUR(P_TDS_PAYMENT_TYPE IN VARCHAR2) IS
145: SELECT

Line 161: HR_ORGANIZATION_UNITS

157: SELECT
158: NVL(ATTRIBUTE14
159: ,'NA')
160: FROM
161: HR_ORGANIZATION_UNITS
162: WHERE ORGANIZATION_ID = NVL(CP_ORGANIZATION_ID
163: ,0);
164: CURSOR ATTRIBUTE15_CUR(CP_ORGANIZATION_ID IN NUMBER) IS
165: SELECT

Line 169: HR_ORGANIZATION_UNITS

165: SELECT
166: NVL(ATTRIBUTE15
167: ,'NA')
168: FROM
169: HR_ORGANIZATION_UNITS
170: WHERE ORGANIZATION_ID = NVL(CP_ORGANIZATION_ID
171: ,0);
172: LV_REPORTING_LEVEL VARCHAR2(2000);
173: LN_REPORTING_ENTITY_ID NUMBER;