APPS.IBY_FNDCPT_SETUP_PUB dependencies on DUAL

Line 363: FROM dual;

359: ELSIF (x_payer_attribs_id IS NULL) THEN
360:
361: SELECT iby_external_payers_all_s.nextval
362: INTO x_payer_attribs_id
363: FROM dual;
364:
365: INSERT INTO iby_external_payers_all
366: (ext_payer_id, payment_function, party_id, org_type, org_id,
367: cust_account_id, acct_site_use_id, bank_charge_bearer_code,

Line 774: FROM DUAL;

770: IF (x_assignment_id IS NULL) THEN
771:
772: SELECT iby_ext_party_pmt_mthds_s.NEXTVAL
773: INTO x_assignment_id
774: FROM DUAL;
775:
776: INSERT INTO iby_ext_party_pmt_mthds
777: (ext_party_pmt_mthd_id, payment_method_code, payment_flow,
778: ext_pmt_party_id, payment_function, primary_flag, inactive_date,

Line 1367: FROM DUAL;

1363:
1364: IF (x_assign_id IS NULL) THEN
1365: SELECT iby_pmt_instr_uses_all_s.nextval
1366: INTO x_assign_id
1367: FROM DUAL;
1368:
1369: INSERT INTO iby_pmt_instr_uses_all
1370: (instrument_payment_use_id, ext_pmt_party_id, instrument_type,
1371: instrument_id, payment_function, payment_flow, order_of_preference,

Line 3410: select IBY_DEBIT_AUTHORIZATIONS_S.nextval into l_seq_number from dual;

3406: UPDATE IBY_DEBIT_AUTHORIZATIONS SET DEBIT_AUTH_END = SYSDATE,
3407: CURR_REC_INDI = 'N'
3408: WHERE DEBIT_AUTHORIZATION_ID = p_debit_auth_id;
3409:
3410: select IBY_DEBIT_AUTHORIZATIONS_S.nextval into l_seq_number from dual;
3411:
3412: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3413: print_debuginfo('Creating the new Mandate:',
3414: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);