APPS.IBY_IMPORT_PMT_ACK_DATA_PUB dependencies on DUAL

Line 264: FROM dual

260: END IF;
261: BEGIN
262: SELECT 0
263: INTO l_access
264: FROM dual
265: WHERE EXISTS
266: (SELECT NULL
267: FROM iby_payments_all
268: WHERE payment_reference_number = P_PAYMENT_REF_NUMBER

Line 309: select iby_ack_pmt_all_s.NEXTVAL into l_ack_pmt_id from dual;

305: l_pmt_ack_status := Get_Payment_Ack_ASatus(P_BANK_STATUS_CODE);
306:
307: -- Inserting record in to IBY_ACK_PMT_ALL
308:
309: select iby_ack_pmt_all_s.NEXTVAL into l_ack_pmt_id from dual;
310:
311: INSERT INTO iby_ack_pmt_all
312: ( ack_pmt_id, payment_ref_number,payment_instruction_ref_number
313: ,bank_status_code,payment_ack_status,acknowledgement_date,bank_assigned_ref_code1, bank_assigned_ref_code2