APPS.JAI_AP_UTILS_PKG dependencies on PO_VENDORS

Line 88: PO_VENDORS pv,

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
92: AND pv.vendor_id = jibh.vendor_id;

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

217: jibh.VENDOR_SITE_ID, -- VENDOR_SITE_ID,
218: jibh.PLA_AMOUNT, -- TOTAL,
219: p_currency_code, -- DEFAULT_CURRENCY_CODE,
220: -- Bug 5141305. Added by Lakshmi Gopalsami
221: -- Removed the reference to accts_pay_code_combination_id of po_vendors
222: pvs.ACCTS_PAY_CODE_COMBINATION_ID,
223: lv_source,
224: v_ORG_ID, -- ORG_ID
225: ln_legal_entity_id , -- LEGAL_ENTITY_ID

Line 231: PO_VENDORS pv,

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
235: AND pv.vendor_id = jibh.vendor_id

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

555: -- Added by Wenqiong Zhou for Bug #1168411 BOE enhancement End
556: jibh.boe_amount - nvl(jibh.depb_amount,0), -- total,/*Bug 5607160 bduvarag*/
557: p_currency_code, -- default_currency_code,
558: -- Bug 5141305. Added by Lakshmi Gopalsami
559: -- Removed the reference to accts_pay_code_combination_id of po_vendors
560: pvs.ACCTS_PAY_CODE_COMBINATION_ID,
561: lv_source,
562: trunc(jibh.import_date), -- Vijay Shankar for bug#3049198
563: v_org_id , -- org_id,

Line 581: po_vendors pv,

577: NULL
578: -- Added by Wenqiong Zhou for Bug #1168411 BOE enhancement End
579: FROM
580: JAI_CMN_BOE_HDRS jibh,
581: po_vendors pv,
582: po_vendor_sites_all pvs
583: where jibh.boe_id = p_boe_id
584: and pvs.vendor_site_id (+)= jibh.vendor_site_id
585: and pv.vendor_id = jibh.vendor_id

Line 2035: P_vendor_id IN PO_VENDORS.vendor_id%TYPE,

2031:
2032:
2033: Procedure pan_update ( P_errbuf OUT NOCOPY varchar2,
2034: P_return_code OUT NOCOPY varchar2,
2035: P_vendor_id IN PO_VENDORS.vendor_id%TYPE,
2036: P_old_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
2037: P_new_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
2038: P_debug_flag IN varchar2) is
2039: