55:
56: CURSOR c_chk_prms IS
57: SELECT adv.paid_invoices_flag,
58: adv.process
59: FROM ap_duplicate_vendors adv
60: WHERE adv.vendor_id = p_new_vendor_id
61: AND adv.duplicate_vendor_id = p_old_vendor_id
62: AND adv.duplicate_vendor_site_id = p_old_vendor_site_id
63: AND adv.process_flag IN ('S','D');
61: AND adv.duplicate_vendor_id = p_old_vendor_id
62: AND adv.duplicate_vendor_site_id = p_old_vendor_site_id
63: AND adv.process_flag IN ('S','D');
64:
65: l_paid_invoices_flag ap_duplicate_vendors.paid_invoices_flag%TYPE;
66: l_process ap_duplicate_vendors.process%TYPE;
67:
68: BEGIN
69:
62: AND adv.duplicate_vendor_site_id = p_old_vendor_site_id
63: AND adv.process_flag IN ('S','D');
64:
65: l_paid_invoices_flag ap_duplicate_vendors.paid_invoices_flag%TYPE;
66: l_process ap_duplicate_vendors.process%TYPE;
67:
68: BEGIN
69:
70: -- Standard call to check for call compatibility