APPS.IEX_PAYMENTS_PUB dependencies on DUAL

Line 710: select IEX_PAYMENTS_S.NEXTVAL from dual;

706: l_call_payment_processor varchar2(5);
707:
708: -- generate new payment
709: CURSOR pay_genid_crs IS
710: select IEX_PAYMENTS_S.NEXTVAL from dual;
711:
712: -- generate new del_pay_xref
713: CURSOR dpx_genid_crs IS
714: select IEX_DEL_PAY_XREF_S.NEXTVAL from dual;

Line 714: select IEX_DEL_PAY_XREF_S.NEXTVAL from dual;

710: select IEX_PAYMENTS_S.NEXTVAL from dual;
711:
712: -- generate new del_pay_xref
713: CURSOR dpx_genid_crs IS
714: select IEX_DEL_PAY_XREF_S.NEXTVAL from dual;
715:
716: -- generate new pay_receipt
717: CURSOR pad_genid_crs IS
718: select IEX_PAY_RECEIPT_XREF_S.NEXTVAL from dual;

Line 718: select IEX_PAY_RECEIPT_XREF_S.NEXTVAL from dual;

714: select IEX_DEL_PAY_XREF_S.NEXTVAL from dual;
715:
716: -- generate new pay_receipt
717: CURSOR pad_genid_crs IS
718: select IEX_PAY_RECEIPT_XREF_S.NEXTVAL from dual;
719:
720: -- generate new receipt number
721: CURSOR rc_genid_crs IS
722: select IEX_RECEIPT_NUMBER_S.NEXTVAL from dual;

Line 722: select IEX_RECEIPT_NUMBER_S.NEXTVAL from dual;

718: select IEX_PAY_RECEIPT_XREF_S.NEXTVAL from dual;
719:
720: -- generate new receipt number
721: CURSOR rc_genid_crs IS
722: select IEX_RECEIPT_NUMBER_S.NEXTVAL from dual;
723:
724: -- get del_id from iex_delinquencies table
725: CURSOR get_delid_crs(p_payment_schedule_id number) IS
726: select delinquency_id

Line 1820: select IEX_PAYMENTS_S.NEXTVAL from dual;

1816: l_source_object_code varchar2(20);
1817:
1818: -- generate new payment
1819: CURSOR pay_genid_crs IS
1820: select IEX_PAYMENTS_S.NEXTVAL from dual;
1821:
1822: -- generate new tangible id
1823: CURSOR tang_genid_crs IS
1824: select IEX_IPAYMENT_TANGIBLE_S.NEXTVAL from dual;

Line 1824: select IEX_IPAYMENT_TANGIBLE_S.NEXTVAL from dual;

1820: select IEX_PAYMENTS_S.NEXTVAL from dual;
1821:
1822: -- generate new tangible id
1823: CURSOR tang_genid_crs IS
1824: select IEX_IPAYMENT_TANGIBLE_S.NEXTVAL from dual;
1825:
1826: -- generate new pay_okl_xref id
1827: CURSOR pox_genid_crs IS
1828: select iex_pay_okl_xref_s.NEXTVAL from dual;

Line 1828: select iex_pay_okl_xref_s.NEXTVAL from dual;

1824: select IEX_IPAYMENT_TANGIBLE_S.NEXTVAL from dual;
1825:
1826: -- generate new pay_okl_xref id
1827: CURSOR pox_genid_crs IS
1828: select iex_pay_okl_xref_s.NEXTVAL from dual;
1829:
1830: CURSOR get_baid_crs(p_BANKID VARCHAR2,
1831: p_BANKACCOUNTID VARCHAR2,
1832: p_PAYER_ID VARCHAR2) IS