APPS.JAI_AP_UTILS_PKG dependencies on JAI_CMN_RG_PLA_HDRS

Line 87: FROM JAI_CMN_RG_PLA_HDRS jibh,

83: WHERE invoice_id = inv_id;
84:
85: CURSOR for_accounting_date(id NUMBER) IS
86: SELECT jibh.tr6_date
87: FROM JAI_CMN_RG_PLA_HDRS jibh,
88: PO_VENDORS pv,
89: PO_VENDOR_SITES_ALL pvs
90: WHERE jibh.PLA_ID = id
91: AND pvs.vendor_site_id (+)= jibh.vendor_site_id

Line 230: FROM JAI_CMN_RG_PLA_HDRS jibh,

226: jibh.CREATED_BY, -- CREATED_BY,
227: jibh.CREATION_DATE, -- CREATION_DATE,
228: jibh.LAST_UPDATED_BY, -- LAST_UPDATED_BY,
229: jibh.LAST_UPDATE_DATE -- LAST_UPDATE_DATE
230: FROM JAI_CMN_RG_PLA_HDRS jibh,
231: PO_VENDORS pv,
232: PO_VENDOR_SITES_ALL pvs
233: WHERE jibh.PLA_ID = P_PLA_ID
234: AND pvs.vendor_site_id (+)= jibh.vendor_site_id

Line 240: FROM JAI_CMN_RG_PLA_HDRS jibh,

236: AND NVL(pvs.org_id, 0) = NVL(v_org_id, 0);
237:
238: SELECT count(*)
239: into cnt_rec
240: FROM JAI_CMN_RG_PLA_HDRS jibh,
241: JAI_CMN_INVENTORY_ORGS org
242: WHERE jibh.PLA_ID = P_PLA_ID
243: AND org.organization_id = jibh.organization_id
244: AND org.location_id = jibh.location_id;

Line 291: FROM JAI_CMN_RG_PLA_HDRS jibh,

287: jibh.CREATION_DATE, -- CREATION_DATE,
288: jibh.LAST_UPDATED_BY, -- LAST_UPDATED_BY,
289: jibh.LAST_UPDATE_DATE, -- LAST_UPDATE_DATE,
290: NULL -- LAST_UPDATE_LOGIN
291: FROM JAI_CMN_RG_PLA_HDRS jibh,
292: JAI_CMN_INVENTORY_ORGS org
293: WHERE jibh.PLA_ID = P_PLA_ID
294: AND org.organization_id = jibh.organization_id
295: AND org.location_id = 0 ;

Line 334: FROM JAI_CMN_RG_PLA_HDRS jibh,

330: jibh.CREATION_DATE, -- CREATION_DATE,
331: jibh.LAST_UPDATED_BY, -- LAST_UPDATED_BY,
332: jibh.LAST_UPDATE_DATE, -- LAST_UPDATE_DATE,
333: NULL -- LAST_UPDATE_LOGIN
334: FROM JAI_CMN_RG_PLA_HDRS jibh,
335: JAI_CMN_INVENTORY_ORGS org
336: WHERE jibh.PLA_ID = P_PLA_ID
337: AND org.organization_id = jibh.organization_id
338: AND org.location_id = jibh.location_id;