APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_PAYMENTS_ALL

Line 509: FROM iby_payments_all

505: AND payment_instruction_id = p_payment_instruction_id;
506:
507: CURSOR l_pmt_csr (p_payment_instruction_id IN NUMBER) IS
508: SELECT payment_id, payment_status, object_version_number
509: FROM iby_payments_all
510: WHERE payment_instruction_id = p_payment_instruction_id
511: AND payment_status in ('FORMATTED', 'INSTRUCTION_CREATED');
512:
513: CURSOR l_pmt_reprt_csr (p_payment_instruction_id IN NUMBER) IS

Line 515: FROM iby_payments_all

511: AND payment_status in ('FORMATTED', 'INSTRUCTION_CREATED');
512:
513: CURSOR l_pmt_reprt_csr (p_payment_instruction_id IN NUMBER) IS
514: SELECT payment_id, payment_status, object_version_number
515: FROM iby_payments_all
516: WHERE payment_instruction_id = p_payment_instruction_id
517: AND payment_status in ('READY_TO_REPRINT', 'VOID_BY_SETUP_REPRINT', 'VOID_BY_OVERFLOW_REPRINT');
518:
519: BEGIN

Line 585: iby_payments_all

581: debug_level => FND_LOG.LEVEL_STATEMENT,
582: module => l_Debug_Module);
583:
584: UPDATE
585: iby_payments_all
586: SET
587: payment_status = 'SUBMITTED_FOR_PRINTING',
588: object_version_number = l_payment.object_version_number + 1,
589: last_updated_by = fnd_global.user_id,

Line 609: iby_payments_all

605: debug_level => FND_LOG.LEVEL_STATEMENT,
606: module => l_Debug_Module);
607:
608: UPDATE
609: iby_payments_all
610: SET
611: payment_status = 'SUBMITTED_FOR_PRINTING',
612: object_version_number = l_payment.object_version_number + 1,
613: last_updated_by = fnd_global.user_id,

Line 627: iby_payments_all

623: debug_level => FND_LOG.LEVEL_STATEMENT,
624: module => l_Debug_Module);
625:
626: UPDATE
627: iby_payments_all
628: SET
629: payment_status = 'VOID_BY_SETUP',
630: object_version_number = l_payment.object_version_number + 1,
631: last_updated_by = fnd_global.user_id,

Line 645: iby_payments_all

641: debug_level => FND_LOG.LEVEL_STATEMENT,
642: module => l_Debug_Module);
643:
644: UPDATE
645: iby_payments_all
646: SET
647: payment_status = 'VOID_BY_OVERFLOW',
648: object_version_number = l_payment.object_version_number + 1,
649: last_updated_by = fnd_global.user_id,

Line 674: iby_payments_all

670: debug_level => FND_LOG.LEVEL_STATEMENT,
671: module => l_Debug_Module);
672:
673: UPDATE
674: iby_payments_all
675: SET
676: payment_status = 'FORMATTED',
677: object_version_number = l_payment.object_version_number + 1,
678: last_updated_by = fnd_global.user_id,

Line 701: iby_payments_all

697: debug_level => FND_LOG.LEVEL_STATEMENT,
698: module => l_Debug_Module);
699:
700: UPDATE
701: iby_payments_all
702: SET
703: payment_status = 'FORMATTED',
704: object_version_number = l_payment.object_version_number + 1,
705: last_updated_by = fnd_global.user_id,

Line 755: iby_payments_all

751: debug_level => FND_LOG.LEVEL_STATEMENT,
752: module => l_Debug_Module);
753:
754: UPDATE
755: iby_payments_all
756: SET
757: payment_status = 'FORMATTED',
758: object_version_number = l_payment.object_version_number + 1,
759: last_updated_by = fnd_global.user_id,

Line 789: iby_payments_all

785: debug_level => FND_LOG.LEVEL_STATEMENT,
786: module => l_Debug_Module);
787:
788: UPDATE
789: iby_payments_all
790: SET
791: payment_status = 'FORMATTED',
792: object_version_number = l_payment.object_version_number + 1,
793: last_updated_by = fnd_global.user_id,

Line 842: iby_payments_all

838: debug_level => FND_LOG.LEVEL_STATEMENT,
839: module => l_Debug_Module);
840:
841: UPDATE
842: iby_payments_all
843: SET
844: payment_status = 'TRANSMITTED',
845: object_version_number = l_payment.object_version_number + 1,
846: last_updated_by = fnd_global.user_id,

Line 904: iby_payments_all

900: debug_level => FND_LOG.LEVEL_STATEMENT,
901: module => l_Debug_Module);
902:
903: UPDATE
904: iby_payments_all
905: SET
906: payment_status = 'FORMATTED',
907: object_version_number = l_payment.object_version_number + 1,
908: last_updated_by = fnd_global.user_id,

Line 1110: FROM iby_docs_payable_all doc, iby_payments_all pmt,

1106: IS
1107:
1108: CURSOR l_doc_csr (p_payment_instruction_id IN NUMBER) IS
1109: SELECT document_payable_id
1110: FROM iby_docs_payable_all doc, iby_payments_all pmt,
1111: iby_pay_instructions_all ins
1112: WHERE ins.payment_instruction_id = p_payment_instruction_id
1113: AND ins.payment_instruction_id = pmt.payment_instruction_id
1114: AND doc.straight_through_flag = 'Y'