APPS.IBY_FD_USER_API_PUB dependencies on IBY_PAYMENTS_ALL

Line 427: from iby_payments_all

423: into l_access
424: from dual
425: where exists
426: (select null
427: from iby_payments_all
428: where payment_instruction_id = p_instruction_id
429: and org_id <> -1
430: and MO_GLOBAL.CHECK_ACCESS(org_id) = 'N');
431:

Line 506: from iby_payments_all

502: into l_access
503: from dual
504: where exists
505: (select null
506: from iby_payments_all
507: where payment_instruction_id = p_instruction_id
508: and org_id <> -1
509: and MO_GLOBAL.CHECK_ACCESS(org_id) = 'N');
510:

Line 854: from iby_payments_all

850: into l_access
851: from dual
852: where exists
853: (select null
854: from iby_payments_all
855: where payment_instruction_id = p_instruction_id
856: and org_id <> -1
857: and MO_GLOBAL.CHECK_ACCESS(org_id) = 'N');
858:

Line 965: FROM IBY_PAYMENTS_ALL PMT

961: PAYMENTS_COMPLETE_CODE,
962: REQUEST_ID
963: FROM IBY_PAY_INSTRUCTIONS_ALL INSTR
964: WHERE EXISTS (SELECT 'PAYMENTS'
965: FROM IBY_PAYMENTS_ALL PMT
966: WHERE PMT.PAYMENT_SERVICE_REQUEST_ID= ppr_id
967: AND PMT.PAYMENT_INSTRUCTION_ID = InStr.PAYMENT_INSTRUCTION_ID);
968:
969: BEGIN