APPS.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on PO_VENDOR_SITES_ALL

Line 1522: FROM po_vendor_sites_all

1518: CURSOR for_terms_id(ven_id NUMBER,ven_site_id NUMBER) IS
1519: SELECT terms_id,
1520: --payment_method_lookup_code, --commented the column by Sanjikum for Bug#4482462
1521: pay_group_lookup_code
1522: FROM po_vendor_sites_all
1523: WHERE vendor_id = pn_vendor_id
1524: AND vendor_site_id = pn_vendor_site_id;
1525:
1526: CURSOR for_terms_id_2(ven_id NUMBER) IS

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

2355: WHERE regime_id = pn_regime_id
2356: AND registration_type = p_reg_type --rchandan for bug#4428980
2357: ORDER BY 1 ASC;
2358:
2359: CURSOR cur_vendor_org_id(c_vendor_id po_vendor_sites_all.vendor_id%TYPE,
2360: c_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE)
2361: IS
2362: SELECT org_id
2363: FROM po_vendor_sites_all

Line 2360: c_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE)

2356: AND registration_type = p_reg_type --rchandan for bug#4428980
2357: ORDER BY 1 ASC;
2358:
2359: CURSOR cur_vendor_org_id(c_vendor_id po_vendor_sites_all.vendor_id%TYPE,
2360: c_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE)
2361: IS
2362: SELECT org_id
2363: FROM po_vendor_sites_all
2364: WHERE vendor_id = c_vendor_id

Line 2363: FROM po_vendor_sites_all

2359: CURSOR cur_vendor_org_id(c_vendor_id po_vendor_sites_all.vendor_id%TYPE,
2360: c_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE)
2361: IS
2362: SELECT org_id
2363: FROM po_vendor_sites_all
2364: WHERE vendor_id = c_vendor_id
2365: AND vendor_site_id = c_vendor_site_id;
2366:
2367: CURSOR cur_regime_code IS /* 4245365*/