APPS.IBY_PAYMENT_MANAGER_PKG dependencies on DUAL

Line 155: -- Need to check the payment instruction and individual payments.

151: /* IBY IN PROCESS. */
152: /* PAYMENTS_CREATED and it can be in either processing or need action group */
153: --Special case Payment Created
154: ELSIF c_rec_snap.payment_service_request_status IN ('PAYMENTS_CREATED') THEN
155: -- Need to check the payment instruction and individual payments.
156: l_access := 'N';
157: --Check org access also verifies the Payment Instruction statuses that are valid.
158: l_access := check_org_access(c_rec_snap.payment_service_request_id);
159: IF l_access = 'Y'

Line 167: FROM dual

163: -- For Processing Action.
164: BEGIN
165: SELECT 'Y'
166: INTO l_process_count
167: FROM dual
168: WHERE EXISTS
169: (SELECT 'PROCESSING'
170: FROM iby_payments_all pmt
171: WHERE pmt.payment_service_request_id =c_rec_snap.payment_service_request_id

Line 220: FROM DUAL;

216: -- dbms_output.put_line('Outputs:: Action::'||l_need_action ||' Processing::'||l_processing||' Terminated::'||l_terminated||' Errors::'||l_errors||' Completed::'|| l_completed);
217:
218: SELECT l_need_action,l_processing,l_terminated,l_errors,l_completed
219: INTO l_ret_val
220: FROM DUAL;
221: --INSERTING INTO PIPE SO IT CAN BE QUERIED.
222: PIPE ROW( l_ret_val);
223: RETURN ;
224: END get_psr_snapshot_pipe;