APPS.INV_VIEW_MTL_TXN dependencies on HR_ALL_ORGANIZATION_UNITS

Line 132: FROM HR_ALL_ORGANIZATION_UNITS HAOU

128: IF (p_owning_tp_type IS NULL OR p_owning_tp_type=2) THEN
129: BEGIN
130: SELECT (MP.organization_code||'-'||HAOU.name)
131: INTO x_owning_organization_name
132: FROM HR_ALL_ORGANIZATION_UNITS HAOU
133: , MTL_PARAMETERS MP
134: WHERE HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
135: AND HAOU.ORGANIZATION_ID = p_owning_organization_id;
136: EXCEPTION

Line 164: FROM HR_ALL_ORGANIZATION_UNITS HAOU

160: p_transaction_action_id = 6) THEN
161: BEGIN
162: SELECT (MP.organization_code||'-'||HAOU.name)
163: INTO x_xfr_owning_organization_name
164: FROM HR_ALL_ORGANIZATION_UNITS HAOU
165: , MTL_PARAMETERS MP
166: WHERE HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
167: AND HAOU.ORGANIZATION_ID = p_xfr_owning_organization_id;
168: EXCEPTION

Line 191: FROM HR_ALL_ORGANIZATION_UNITS HAOU

187: IF (p_PLANNING_TP_TYPE IS NULL OR p_planning_tp_type=2) THEN
188: BEGIN
189: SELECT (MP.organization_code||'-'||HAOU.name), NULL
190: INTO x_supplier_site_name, x_supplier
191: FROM HR_ALL_ORGANIZATION_UNITS HAOU
192: , MTL_PARAMETERS MP
193: WHERE HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
194: AND HAOU.ORGANIZATION_ID = p_planning_organization_id;
195: EXCEPTION