APPS.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on PO_VENDOR_SITES_ALL

Line 997: FROM po_vendor_sites_all

993: CURSOR for_terms_id(ven_id NUMBER,ven_site_id NUMBER) IS
994: SELECT terms_id,
995: --payment_method_lookup_code, --commented the column by Sanjikum for Bug#4482462
996: pay_group_lookup_code
997: FROM po_vendor_sites_all
998: WHERE vendor_id = pn_vendor_id
999: AND vendor_site_id = pn_vendor_site_id;
1000:
1001: CURSOR for_terms_id_2(ven_id NUMBER) IS

Line 1751: CURSOR cur_vendor_org_id(c_vendor_id po_vendor_sites_all.vendor_id%TYPE,

1747: WHERE regime_id = pn_regime_id
1748: AND registration_type = p_reg_type --rchandan for bug#4428980
1749: ORDER BY 1 ASC;
1750:
1751: CURSOR cur_vendor_org_id(c_vendor_id po_vendor_sites_all.vendor_id%TYPE,
1752: c_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE)
1753: IS
1754: SELECT org_id
1755: FROM po_vendor_sites_all

Line 1752: c_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE)

1748: AND registration_type = p_reg_type --rchandan for bug#4428980
1749: ORDER BY 1 ASC;
1750:
1751: CURSOR cur_vendor_org_id(c_vendor_id po_vendor_sites_all.vendor_id%TYPE,
1752: c_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE)
1753: IS
1754: SELECT org_id
1755: FROM po_vendor_sites_all
1756: WHERE vendor_id = c_vendor_id

Line 1755: FROM po_vendor_sites_all

1751: CURSOR cur_vendor_org_id(c_vendor_id po_vendor_sites_all.vendor_id%TYPE,
1752: c_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE)
1753: IS
1754: SELECT org_id
1755: FROM po_vendor_sites_all
1756: WHERE vendor_id = c_vendor_id
1757: AND vendor_site_id = c_vendor_site_id;
1758:
1759: CURSOR cur_regime_code IS /* 4245365*/