APPS.IBY_UTILITY_PVT dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 876: FROM iby_pay_instructions_all instr

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
877: WHERE instr.payment_instruction_id = pmt.payment_instruction_id
878: AND instr.payment_instruction_status IN ('CREATION_ERROR', 'FORMATTED_READY_TO_TRANSMIT', 'TRANSMISSION_FAILED',
879: 'FORMATTED_READY_FOR_PRINTING', 'SUBMITTED_FOR_PRINTING', 'CREATED_READY_FOR_PRINTING',
880: 'CREATED_READY_FOR_FORMATTING', 'FORMATTED', 'CREATED', 'TRANSMITTED')

Line 932: FROM iby_pay_instructions_all inst

928: 'FAILED_VALIDATION', 'FAILED_BY_CALLING_APP', 'FAILED_BY_REJECTION_LEVEL')
929: AND pmt.payments_complete_flag <> 'Y'
930: AND NOT EXISTS
931: (SELECT 'NEED_ACTION'
932: FROM iby_pay_instructions_all inst
933: WHERE pmt.payment_instruction_id = inst.payment_instruction_id
934: AND inst.payment_instruction_status IN('CREATION_ERROR',
935: 'FORMATTED_READY_TO_TRANSMIT',
936: 'TRANSMISSION_FAILED',

Line 1318: FROM iby_pay_instructions_all ins,

1314: 'XSL-XML','XML',
1315: 'PDF','PDF'),'PDF', 'IBY_FD_PAYMENT_FORMAT','IBY_FD_PAYMENT_FORMAT_TEXT')
1316: into
1317: l_conc_prog
1318: FROM iby_pay_instructions_all ins,
1319: iby_payment_profiles pp,
1320: iby_formats_b format,
1321: XDO_TEMPLATES_B temp
1322: WHERE ins.payment_instruction_id = p_pay_instruction_id

Line 1479: FROM iby_pay_instructions_all inst

1475: 'REMOVED_REQUEST_TERMINATED', 'ISSUED', 'TRANSMITTED', 'REJECTED')
1476: AND pmt.payments_complete_flag <> 'Y'
1477: AND NOT EXISTS
1478: (SELECT 'NEED_ACTION'
1479: FROM iby_pay_instructions_all inst
1480: WHERE pmt.payment_instruction_id = inst.payment_instruction_id
1481: AND (inst.payment_instruction_status IN('CREATION_ERROR', 'FORMATTED_READY_TO_TRANSMIT', 'TRANSMISSION_FAILED', 'FORMATTED_READY_FOR_PRINTING', 'SUBMITTED_FOR_PRINTING',
1482: 'CREATED_READY_FOR_PRINTING', 'CREATED_READY_FOR_FORMATTING', 'FORMATTED', 'CREATED', 'FORMATTED_ELECTRONIC')
1483: OR (inst.payment_instruction_status = 'TRANSMITTED' AND IBY_FD_USER_API_PUB.Is_transmitted_Pmt_Inst_Compl(inst.PAYMENT_INSTRUCTION_ID) = 'N'))

Line 1542: iby_pay_instructions_all instr

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',
1546: 'SUBMITTED_FOR_PRINTING', 'CREATED_READY_FOR_PRINTING', 'CREATED_READY_FOR_FORMATTING', 'FORMATTED', 'CREATED')

Line 1687: FROM iby_pay_instructions_all instr

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
1688: WHERE instr.payment_instruction_id = pmt.payment_instruction_id
1689: AND instr.payment_instruction_status IN ('CREATION_ERROR', 'FORMATTED_READY_TO_TRANSMIT', 'TRANSMISSION_FAILED',
1690: 'FORMATTED_READY_FOR_PRINTING', 'SUBMITTED_FOR_PRINTING', 'CREATED_READY_FOR_PRINTING',
1691: 'CREATED_READY_FOR_FORMATTING', 'FORMATTED', 'CREATED', 'TRANSMITTED')

Line 1755: FROM iby_pay_instructions_all inst

1751: 'FAILED_VALIDATION', 'FAILED_BY_CALLING_APP', 'FAILED_BY_REJECTION_LEVEL')
1752: AND pmt.payments_complete_flag <> 'Y'
1753: AND NOT EXISTS
1754: (SELECT 'NEED_ACTION'
1755: FROM iby_pay_instructions_all inst
1756: WHERE pmt.payment_instruction_id = inst.payment_instruction_id
1757: AND inst.payment_instruction_status IN('CREATION_ERROR',
1758: 'FORMATTED_READY_TO_TRANSMIT',
1759: 'TRANSMISSION_FAILED',