APPS.IBY_FD_USER_API_PUB dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 608: from IBY_PAY_INSTRUCTIONS_ALL

604: END IF;
605:
606: select count(*)
607: into l_instr_sra_ok
608: from IBY_PAY_INSTRUCTIONS_ALL
609: where generate_sep_remit_advice_flag = 'Y'
610: and (REMITTANCE_ADVICE_CREATED_FLAG = 'N' or
611: IBY_FD_POST_PICP_PROGS_PVT.get_allow_multiple_sra_flag(p_instr_id) = 'Y')
612: and payment_instruction_status not in ('CREATION_ERROR', 'RETRY_CREATION', 'TERMINATED')

Line 625: from iby_pay_instructions_all ins,

621: select sra_setup.remittance_advice_format_code,
622: f.format_name
623: into x_default_sra_format_code,
624: x_default_sra_format_name
625: from iby_pay_instructions_all ins,
626: iby_payment_profiles pp,
627: iby_remit_advice_setup sra_setup,
628: iby_formats_vl f
629: where ins.payment_instruction_id = p_instr_id

Line 701: FROM iby_pay_instructions_all

697: BEGIN
698:
699: SELECT payments_complete_code
700: INTO l_complete_code
701: FROM iby_pay_instructions_all
702: WHERE payment_instruction_id = p_instruction_id;
703:
704: IF (l_complete_code = 'YES') THEN
705: RETURN 'Y';

Line 722: FROM iby_pay_instructions_all inst, iby_payment_profiles pp

718: BEGIN
719:
720: SELECT inst.payments_complete_code, pp.mark_complete_event
721: INTO l_complete_code, l_mark_complete_event
722: FROM iby_pay_instructions_all inst, iby_payment_profiles pp
723: WHERE inst.payment_profile_id = pp.payment_profile_id
724: AND inst.payment_instruction_id = p_instruction_id;
725:
726: IF (l_complete_code = 'YES') THEN

Line 766: from iby_pay_instructions_all

762: into l_instruction_status,
763: l_process_type,
764: l_pmt_complete_code,
765: l_request_id
766: from iby_pay_instructions_all
767: where payment_instruction_id = p_instruction_id;
768:
769: print_debuginfo(l_module_name,'Instruction Status::'||l_instruction_status);
770: print_debuginfo(l_module_name,'Process Type::'||l_process_type);

Line 963: FROM IBY_PAY_INSTRUCTIONS_ALL INSTR

959: PAYMENT_INSTRUCTION_ID,
960: ORG_ID,
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);