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 827: FROM pos_supplier_mappings psm

823: l_rec l_cur%ROWTYPE;
824:
825: CURSOR l_cur2 IS
826: SELECT vendor_id, party_id
827: FROM pos_supplier_mappings psm
828: WHERE mapping_id = l_rec.mapping_id;
829:
830: l_rec2 l_cur2%ROWTYPE;
831: l_lock_id number;

Line 970: FROM pos_supplier_mappings psm

966: l_rec l_cur%ROWTYPE;
967:
968: CURSOR l_cur2 IS
969: SELECT vendor_id, party_id
970: FROM pos_supplier_mappings psm
971: WHERE mapping_id = l_rec.mapping_id;
972:
973: l_rec2 l_cur2%ROWTYPE;
974:

Line 1137: FROM pos_supplier_mappings psm

1133: l_rec l_cur%ROWTYPE;
1134:
1135: CURSOR l_cur2 IS
1136: SELECT vendor_id, party_id
1137: FROM pos_supplier_mappings psm
1138: WHERE mapping_id = l_rec.mapping_id;
1139:
1140: l_rec2 l_cur2%ROWTYPE;
1141:

Line 1244: FROM pos_supplier_mappings psm

1240: l_rec l_cur%ROWTYPE;
1241:
1242: CURSOR l_cur2 IS
1243: SELECT vendor_id, party_id
1244: FROM pos_supplier_mappings psm
1245: WHERE mapping_id = l_rec.mapping_id;
1246:
1247: l_rec2 l_cur2%ROWTYPE;
1248: l_lock_id number;

Line 1965: POS_SUPPLIER_MAPPINGS PSM

1961: l_contactPartyId,
1962: l_suppPartyId
1963: FROM
1964: POS_CONTACT_REQUESTS PCR,
1965: POS_SUPPLIER_MAPPINGS PSM
1966: WHERE CONTACT_REQUEST_ID=p_req_id_tbl(i)
1967: AND PCR.MAPPING_ID=PSM.MAPPING_ID;
1968:
1969: /* Below query checks for the duplicate contacts */