APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 274: pos_supplier_mappings psm,

270: pcr.contact_party_id,
271: pcar.party_site_id
272: FROM pos_cont_addr_requests pcar,
273: pos_contact_requests pcr,
274: pos_supplier_mappings psm,
275: po_vendors pv
276: WHERE pcar.contact_req_id = p_contact_request_id
277: AND pcar.request_status = 'PENDING'
278: AND pcar.party_site_id IS NOT NULL

Line 338: pos_supplier_mappings psm,

334: WHERE cont_addr_request_id IN
335: (SELECT pcar.cont_addr_request_id
336: FROM pos_cont_addr_requests pcar,
337: pos_contact_requests pcr,
338: pos_supplier_mappings psm,
339: po_vendors pv
340: WHERE pcar.contact_req_id = p_contact_request_id
341: AND pcar.request_status = 'PENDING'
342: AND pcar.mapping_id = psm.mapping_id

Line 817: FROM pos_supplier_mappings psm

813: l_rec l_cur%ROWTYPE;
814:
815: CURSOR l_cur2 IS
816: SELECT vendor_id, party_id
817: FROM pos_supplier_mappings psm
818: WHERE mapping_id = l_rec.mapping_id;
819:
820: l_rec2 l_cur2%ROWTYPE;
821: l_lock_id number;

Line 960: FROM pos_supplier_mappings psm

956: l_rec l_cur%ROWTYPE;
957:
958: CURSOR l_cur2 IS
959: SELECT vendor_id, party_id
960: FROM pos_supplier_mappings psm
961: WHERE mapping_id = l_rec.mapping_id;
962:
963: l_rec2 l_cur2%ROWTYPE;
964:

Line 1083: FROM pos_supplier_mappings psm

1079: l_rec l_cur%ROWTYPE;
1080:
1081: CURSOR l_cur2 IS
1082: SELECT vendor_id, party_id
1083: FROM pos_supplier_mappings psm
1084: WHERE mapping_id = l_rec.mapping_id;
1085:
1086: l_rec2 l_cur2%ROWTYPE;
1087:

Line 1190: FROM pos_supplier_mappings psm

1186: l_rec l_cur%ROWTYPE;
1187:
1188: CURSOR l_cur2 IS
1189: SELECT vendor_id, party_id
1190: FROM pos_supplier_mappings psm
1191: WHERE mapping_id = l_rec.mapping_id;
1192:
1193: l_rec2 l_cur2%ROWTYPE;
1194: l_lock_id number;

Line 1911: POS_SUPPLIER_MAPPINGS PSM

1907: l_contactPartyId,
1908: l_suppPartyId
1909: FROM
1910: POS_CONTACT_REQUESTS PCR,
1911: POS_SUPPLIER_MAPPINGS PSM
1912: WHERE CONTACT_REQUEST_ID=p_req_id_tbl(i)
1913: AND PCR.MAPPING_ID=PSM.MAPPING_ID;
1914:
1915: /* Below query checks for the duplicate contacts */