APPS.JAI_AP_UTILS_PKG dependencies on PO_VENDORS

Line 76: PO_VENDORS pv,

72:
73: CURSOR for_accounting_date(id NUMBER) IS
74: SELECT jibh.tr6_date
75: FROM JAI_CMN_RG_PLA_HDRS jibh,
76: PO_VENDORS pv,
77: PO_VENDOR_SITES_ALL pvs
78: WHERE jibh.PLA_ID = id
79: AND pvs.vendor_site_id (+)= jibh.vendor_site_id
80: AND pv.vendor_id = jibh.vendor_id;

Line 209: -- Removed the reference to accts_pay_code_combination_id of po_vendors

205: jibh.VENDOR_SITE_ID, -- VENDOR_SITE_ID,
206: jibh.PLA_AMOUNT, -- TOTAL,
207: p_currency_code, -- DEFAULT_CURRENCY_CODE,
208: -- Bug 5141305. Added by Lakshmi Gopalsami
209: -- Removed the reference to accts_pay_code_combination_id of po_vendors
210: pvs.ACCTS_PAY_CODE_COMBINATION_ID,
211: lv_source,
212: v_ORG_ID, -- ORG_ID
213: ln_legal_entity_id , -- LEGAL_ENTITY_ID

Line 219: PO_VENDORS pv,

215: jibh.CREATION_DATE, -- CREATION_DATE,
216: jibh.LAST_UPDATED_BY, -- LAST_UPDATED_BY,
217: jibh.LAST_UPDATE_DATE -- LAST_UPDATE_DATE
218: FROM JAI_CMN_RG_PLA_HDRS jibh,
219: PO_VENDORS pv,
220: PO_VENDOR_SITES_ALL pvs
221: WHERE jibh.PLA_ID = P_PLA_ID
222: AND pvs.vendor_site_id (+)= jibh.vendor_site_id
223: AND pv.vendor_id = jibh.vendor_id

Line 499: -- Removed the reference to accts_pay_code_combination_id of po_vendors

495: jibh.vendor_site_id,
496: round(jibh.boe_amount), -- total,/*Bug 5607160 bduvarag*/
497: p_currency_code, -- default_currency_code,
498: -- Bug 5141305. Added by Lakshmi Gopalsami
499: -- Removed the reference to accts_pay_code_combination_id of po_vendors
500: pvs.ACCTS_PAY_CODE_COMBINATION_ID,
501: lv_source,
502: trunc(jibh.import_date), -- Vijay Shankar for bug#3049198
503: v_org_id , -- org_id,

Line 511: po_vendors pv,

507: jibh.last_updated_by,
508: trunc(jibh.last_update_date)
509: FROM
510: JAI_CMN_BOE_HDRS jibh,
511: po_vendors pv,
512: po_vendor_sites_all pvs
513: where jibh.boe_id = p_boe_id
514: and pvs.vendor_site_id (+)= jibh.vendor_site_id
515: and pv.vendor_id = jibh.vendor_id

Line 1813: P_vendor_id IN PO_VENDORS.vendor_id%TYPE,

1809:
1810:
1811: Procedure pan_update ( P_errbuf OUT NOCOPY varchar2,
1812: P_return_code OUT NOCOPY varchar2,
1813: P_vendor_id IN PO_VENDORS.vendor_id%TYPE,
1814: P_old_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
1815: P_new_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
1816: P_debug_flag IN varchar2) is
1817: