DBA Data[Home] [Help]

APPS.PN_EXP_TO_AP dependencies on DUAL

Line 681: FROM DUAL

677: CURSOR c_inv_num( p_invoice_num IN VARCHAR2
678: ,p_vendor_id IN NUMBER
679: ,p_org_ID IN NUMBER) IS
680: SELECT 1
681: FROM DUAL
682: WHERE EXISTS(SELECT 1
683: FROM ap_invoices_all
684: WHERE invoice_num = p_invoice_num
685: AND vendor_id = p_vendor_id

Line 692: FROM DUAL

688: CURSOR c_inv_num_itf( p_invoice_num IN VARCHAR2
689: ,p_vendor_id IN NUMBER
690: ,p_org_ID IN NUMBER) IS
691: SELECT 1
692: FROM DUAL
693: WHERE EXISTS(SELECT 1
694: FROM ap_invoices_interface
695: WHERE invoice_num = p_invoice_num
696: AND vendor_id = p_vendor_id

Line 2216: FROM dual;

2212: IF p_grp_param IS NULL THEN
2213:
2214: SELECT TO_CHAR(pn_payments_group_s.NEXTVAL)
2215: INTO l_group_id
2216: FROM dual;
2217:
2218: IF p_lease_num_low IS NOT NULL AND
2219: p_lease_num_high IS NOT NULL THEN
2220: