DBA Data[Home] [Help]

APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_VENDOR_SITES_ALL

Line 90: FROM Po_Vendor_Sites_All A

86: WHERE Vendor_Name = p_sugg_vendor_name;
87:
88: CURSOR site_cur(p_sugg_vendor_loc IN VARCHAR2) IS
89: SELECT Vendor_Site_Id
90: FROM Po_Vendor_Sites_All A
91: WHERE A.Vendor_Site_Code = p_sugg_vendor_loc
92: AND A.Vendor_Id = v_vendor_id
93: AND (A.Org_Id = v_org_id
94: OR

Line 1936: FROM Po_Vendor_Sites_All A

1932: WHERE vendor_name = p_sugg_vendor_name;
1933:
1934: CURSOR site_cur(p_sugg_vendor_loc IN VARCHAR2) IS
1935: SELECT Vendor_Site_Id
1936: FROM Po_Vendor_Sites_All A
1937: WHERE A.Vendor_Site_Code = p_sugg_vendor_loc
1938: AND A.Vendor_Id = v_vendor_id
1939: AND (A.Org_Id = v_org_id
1940: OR

Line 2773: FROM Po_vendor_Sites_All A

2769: FROM po_vendors
2770: WHERE vendor_name = p_sugg_vendor_name;
2771:
2772: Cursor site_cur(p_sugg_vendor_loc IN VARCHAR2) IS SELECT vendor_Site_Id
2773: FROM Po_vendor_Sites_All A
2774: WHERE A.vendor_Site_Code = p_sugg_vendor_loc
2775: AND A.vendor_Id = v_vendor_id
2776: AND nvl(A.Org_Id,0) = nvl(v_org_id,0);
2777: