APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on DUAL

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

664:
665: END IF;
666:
667: IF l_payee_cnt = 0 THEN
668: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_ext_payee_id from dual;
669: insert_payee_row(l_ext_payee_id,
670: l_ext_payee_tab(counter),
671: l_payee_crt_status);
672:

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

940: -- create the payee entity if it does not exist
941: IF (l_payee_id IS NULL) THEN
942: -- Create a default external payee
943: print_debuginfo(l_module,'Inside if l_payee_id is null, trying to insert in external_payees_all ');
944: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_payee_id from dual;
945:
946: l_ext_payee_rec.Payee_Party_Id := p_payee.Party_Id;
947: l_ext_payee_rec.Payee_Party_Site_Id := p_payee.Party_Site_id;
948: l_ext_payee_rec.Supplier_Site_Id := p_payee.Supplier_Site_id;

Line 1046: FROM DUAL;

1042:
1043: IF (x_assign_id IS NULL) THEN
1044: SELECT iby_pmt_instr_uses_all_s.nextval
1045: INTO x_assign_id
1046: FROM DUAL;
1047:
1048: INSERT INTO iby_pmt_instr_uses_all
1049: (instrument_payment_use_id,
1050: ext_pmt_party_id,