APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on DUAL

Line 501: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_ext_payee_id from dual;

497: print_debuginfo(l_module_name, 'Payee count is ' || l_payee_cnt);
498: print_debuginfo(l_module_name, 'Payee Id is ' || l_payee_id);
499:
500: IF l_payee_cnt = 0 THEN
501: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_ext_payee_id from dual;
502: insert_payee_row(l_ext_payee_id,
503: p_ext_payee_tab(counter),
504: l_payee_crt_status);
505:

Line 725: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_payee_id from dual;

721: -- create the payee entity if it does not exist
722: IF (l_payee_id IS NULL) THEN
723: -- Create a default external payee
724: print_debuginfo(l_module,'Inside if l_payee_id is null, trying to insert in external_payees_all ');
725: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_payee_id from dual;
726:
727: l_ext_payee_rec.Payee_Party_Id := p_payee.Party_Id;
728: l_ext_payee_rec.Payee_Party_Site_Id := p_payee.Party_Site_id;
729: l_ext_payee_rec.Supplier_Site_Id := p_payee.Supplier_Site_id;

Line 789: FROM DUAL;

785:
786: IF (x_assign_id IS NULL) THEN
787: SELECT iby_pmt_instr_uses_all_s.nextval
788: INTO x_assign_id
789: FROM DUAL;
790:
791: INSERT INTO iby_pmt_instr_uses_all
792: (instrument_payment_use_id,
793: ext_pmt_party_id,