APPS.IBY_UTILITY_PVT dependencies on IBY_PAYMENTS_ALL

Line 872: FROM iby_payments_all pmt

868: AND iby.process_type = 'STANDARD'
869: AND iby.payment_service_request_status = 'PAYMENTS_CREATED'
870: AND EXISTS
871: (SELECT 'NEED_ACTION_BY_ME'
872: FROM iby_payments_all pmt
873: WHERE iby.payment_service_request_id = pmt.payment_service_request_id
874: AND EXISTS
875: (SELECT 'NEED_ACTION_BY_ME'
876: FROM iby_pay_instructions_all instr

Line 923: FROM iby_payments_all pmt

919: (
920: iby.payment_service_request_status IN ('PAYMENTS_CREATED')
921: AND EXISTS
922: (SELECT 'PROCESSING'
923: FROM iby_payments_all pmt
924: WHERE
925: pmt.payment_service_request_id = iby.payment_service_request_id
926: AND pmt.payment_status NOT IN('REMOVED', 'VOID', 'VOID_BY_SETUP', 'VOID_BY_OVERFLOW', 'REMOVED_PAYMENT_STOPPED',
927: 'REMOVED_DOCUMENT_SPOILED', 'REMOVED_INSTRUCTION_TERMINATED', 'REMOVED_REQUEST_TERMINATED', 'ISSUED', 'TRANSMITTED', 'REJECTED',

Line 1074: FROM iby_payments_all

1070: select count (*) total_pmt_count,
1071: count(case when PAYMENTS_COMPLETE_FLAG = 'Y' then 1 else null
1072: end) pmt_complete_count
1073: into l_total_pmt_count, l_pmt_complete_count /*Bug 7248943*/
1074: FROM iby_payments_all
1075: WHERE payment_service_request_id = p_psr_id
1076: AND payment_status NOT IN ('REMOVED', 'VOID_BY_SETUP',
1077: 'VOID_BY_OVERFLOW', 'REMOVED_PAYMENT_STOPPED',
1078: 'REMOVED_DOCUMENT_SPOILED',

Line 1174: from iby_payments_all

1170: select 1
1171: into l_valid_completed_pmt
1172: from dual
1173: where exists(select 'VALID_PAYMENT'
1174: from iby_payments_all
1175: where payment_service_request_id = p_psr_id
1176: and payments_complete_flag = 'Y'
1177: and payment_status in ('INSTRUCTION_CREATED', 'ISSUED', 'FORMATTED', 'TRANSMITTED'));
1178:

Line 1210: from iby_payments_all

1206: count(case when PAYMENT_STATUS IN ('REMOVED_DOCUMENT_SPOILED',
1207: 'REMOVED_DOCUMENT_SKIPPED') then 1
1208: else null end) pmt_spoil_skip
1209: into l_total_pmt_count, l_instr_count, l_pmt_terminate_count, l_pmt_spoil_skip
1210: from iby_payments_all
1211: WHERE payment_service_request_id = p_psr_id ;
1212: /*Bug 7248943*/
1213:
1214: IF (l_instr_count = 0 AND p_psr_status = 'PAYMENTS_CREATED') THEN

Line 1290: select 'N' into l_access from dual where exists ( select 'Inaccessible org' from iby_payments_all where

1286: THEN
1287: l_access := g_instr_access_table(p_pay_instruction_id).access_flag;
1288: ELSE
1289: begin
1290: select 'N' into l_access from dual where exists ( select 'Inaccessible org' from iby_payments_all where
1291: payment_instruction_id = p_pay_instruction_id and MO_GLOBAL.CHECK_ACCESS(org_id) = 'N');
1292:
1293: Exception
1294: when NO_DATA_FOUND

Line 1472: FROM iby_payments_all pmt

1468: INTO l_process_count
1469: FROM dual
1470: WHERE EXISTS
1471: (SELECT 'PROCESSING'
1472: FROM iby_payments_all pmt
1473: WHERE pmt.payment_service_request_id =c_rec_snap.payment_service_request_id
1474: AND pmt.payment_status NOT IN('REMOVED', 'VOID', 'VOID_BY_SETUP', 'VOID_BY_OVERFLOW', 'REMOVED_PAYMENT_STOPPED', 'REMOVED_DOCUMENT_SPOILED', 'REMOVED_INSTRUCTION_TERMINATED',
1475: 'REMOVED_REQUEST_TERMINATED', 'ISSUED', 'TRANSMITTED', 'REJECTED')
1476: AND pmt.payments_complete_flag <> 'Y'

Line 1541: FROM iby_payments_all pmt,

1537: pmt_all.ORG_ID
1538: FROM
1539: (SELECT DISTINCT pmt.payment_instruction_id INSTR_ID,
1540: pmt.org_id ORG_ID
1541: FROM iby_payments_all pmt,
1542: iby_pay_instructions_all instr
1543: WHERE p_payment_service_request_id = pmt.payment_service_request_id
1544: AND instr.payment_instruction_id = pmt.payment_instruction_id
1545: AND (instr.payment_instruction_status IN ('CREATION_ERROR', 'FORMATTED_READY_TO_TRANSMIT', 'TRANSMISSION_FAILED', 'FORMATTED_READY_FOR_PRINTING',

Line 1683: FROM iby_payments_all pmt

1679: AND iby.process_type = 'STANDARD'
1680: AND iby.payment_service_request_status = 'PAYMENTS_CREATED'
1681: AND EXISTS
1682: (SELECT 'NEED_ACTION_BY_ME'
1683: FROM iby_payments_all pmt
1684: WHERE iby.payment_service_request_id = pmt.payment_service_request_id
1685: AND EXISTS
1686: (SELECT 'NEED_ACTION_BY_ME'
1687: FROM iby_pay_instructions_all instr

Line 1746: FROM iby_payments_all pmt

1742: (
1743: iby.payment_service_request_status IN ('PAYMENTS_CREATED')
1744: AND EXISTS
1745: (SELECT 'PROCESSING'
1746: FROM iby_payments_all pmt
1747: WHERE
1748: pmt.payment_service_request_id = iby.payment_service_request_id
1749: AND pmt.payment_status NOT IN('REMOVED', 'VOID', 'VOID_BY_SETUP', 'VOID_BY_OVERFLOW', 'REMOVED_PAYMENT_STOPPED',
1750: 'REMOVED_DOCUMENT_SPOILED', 'REMOVED_INSTRUCTION_TERMINATED', 'REMOVED_REQUEST_TERMINATED', 'ISSUED', 'TRANSMITTED', 'REJECTED',