APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_PAYMENTS_ALL

Line 549: -- FROM iby_payments_all

545: AND payment_instruction_id = p_payment_instruction_id;
546:
547: -- CURSOR l_pmt_csr (p_payment_instruction_id IN NUMBER) IS
548: -- SELECT payment_id, payment_status, object_version_number
549: -- FROM iby_payments_all
550: -- WHERE payment_instruction_id = p_payment_instruction_id
551: -- AND payment_status in ('FORMATTED', 'INSTRUCTION_CREATED');
552: --
553: -- CURSOR l_pmt_reprt_csr (p_payment_instruction_id IN NUMBER) IS

Line 555: -- FROM iby_payments_all

551: -- AND payment_status in ('FORMATTED', 'INSTRUCTION_CREATED');
552: --
553: -- CURSOR l_pmt_reprt_csr (p_payment_instruction_id IN NUMBER) IS
554: -- SELECT payment_id, payment_status, object_version_number
555: -- FROM iby_payments_all
556: -- WHERE payment_instruction_id = p_payment_instruction_id
557: -- AND payment_status in ('READY_TO_REPRINT', 'VOID_BY_SETUP_REPRINT', 'VOID_BY_OVERFLOW_REPRINT');
558:
559: BEGIN

Line 639: iby_payments_all

635: debug_level => FND_LOG.LEVEL_STATEMENT,
636: module => l_Debug_Module);
637:
638: UPDATE
639: iby_payments_all
640: SET
641: payment_status = 'SUBMITTED_FOR_PRINTING',
642: object_version_number = object_version_number + 1,
643: last_updated_by = fnd_global.user_id,

Line 681: iby_payments_all

677: module => l_Debug_Module);
678:
679:
680: UPDATE
681: iby_payments_all
682: SET
683: payment_status = decode(payment_status,
684: 'READY_TO_REPRINT','SUBMITTED_FOR_PRINTING',
685: 'VOID_BY_SETUP_REPRINT','VOID_BY_SETUP',

Line 711: -- iby_payments_all

707: module => l_Debug_Module);
708:
709:
710: -- UPDATE
711: -- iby_payments_all
712: -- SET
713: -- payment_status = 'VOID_BY_SETUP',
714: -- object_version_number = object_version_number + 1,
715: -- last_updated_by = fnd_global.user_id,

Line 738: -- iby_payments_all

734: module => l_Debug_Module);
735:
736:
737: -- UPDATE
738: -- iby_payments_all
739: -- SET
740: -- payment_status = 'VOID_BY_OVERFLOW',
741: -- object_version_number = object_version_number + 1,
742: -- last_updated_by = fnd_global.user_id,

Line 781: iby_payments_all

777: debug_level => FND_LOG.LEVEL_STATEMENT,
778: module => l_Debug_Module);
779:
780: UPDATE
781: iby_payments_all
782: SET
783: payment_status = 'FORMATTED',
784: object_version_number = object_version_number + 1,
785: last_updated_by = fnd_global.user_id,

Line 823: iby_payments_all

819: debug_level => FND_LOG.LEVEL_STATEMENT,
820: module => l_Debug_Module);
821:
822: UPDATE
823: iby_payments_all
824: SET
825: payment_status = 'FORMATTED',
826: object_version_number = object_version_number + 1,
827: last_updated_by = fnd_global.user_id,

Line 897: iby_payments_all

893: debug_level => FND_LOG.LEVEL_STATEMENT,
894: module => l_Debug_Module);
895:
896: UPDATE
897: iby_payments_all
898: SET
899: payment_status = 'FORMATTED',
900: object_version_number = object_version_number + 1,
901: last_updated_by = fnd_global.user_id,

Line 947: iby_payments_all

943: module => l_Debug_Module);
944:
945:
946: UPDATE
947: iby_payments_all
948: SET
949: payment_status = 'FORMATTED',
950: object_version_number = object_version_number + 1,
951: last_updated_by = fnd_global.user_id,

Line 1022: iby_payments_all

1018: module => l_Debug_Module);
1019:
1020:
1021: UPDATE
1022: iby_payments_all
1023: SET
1024: payment_status = 'TRANSMITTED',
1025: object_version_number = object_version_number + 1,
1026: last_updated_by = fnd_global.user_id,

Line 1109: iby_payments_all

1105: debug_level => FND_LOG.LEVEL_STATEMENT,
1106: module => l_Debug_Module);
1107:
1108: UPDATE
1109: iby_payments_all
1110: SET
1111: payment_status = 'FORMATTED',
1112: object_version_number = object_version_number + 1,
1113: last_updated_by = fnd_global.user_id,

Line 1319: FROM iby_docs_payable_all doc, iby_payments_all pmt,

1315: IS
1316:
1317: CURSOR l_doc_csr (p_payment_instruction_id IN NUMBER) IS
1318: SELECT document_payable_id
1319: FROM iby_docs_payable_all doc, iby_payments_all pmt,
1320: iby_pay_instructions_all ins
1321: WHERE ins.payment_instruction_id = p_payment_instruction_id
1322: AND ins.payment_instruction_id = pmt.payment_instruction_id
1323: AND doc.straight_through_flag = 'Y'