1505: ( SELECT tp_header_id
1506: FROM ecx_tp_details
1507: WHERE ext_process_id IN
1508: ( SELECT ext_process_id
1509: FROM ecx_ext_processes
1510: WHERE direction = 'OUT'
1511: AND transaction_id IN
1512: (SELECT et.transaction_id
1513: FROM ecx_transactions et, ecx_ext_processes ep
1509: FROM ecx_ext_processes
1510: WHERE direction = 'OUT'
1511: AND transaction_id IN
1512: (SELECT et.transaction_id
1513: FROM ecx_transactions et, ecx_ext_processes ep
1514: WHERE transaction_type='DA'
1515: and ep.transaction_id = et.transaction_id
1516: and ep.ext_type =
1517: (select dcry.request_type
1523: );
1524:
1525: CURSOR c_transaction_data IS
1526: SELECT et.transaction_subtype
1527: FROM ecx_transactions et, ecx_ext_processes ep
1528: WHERE transaction_type='DA'
1529: and ep.transaction_id = et.transaction_id
1530: and ep.direction = 'OUT'
1531: and ep.ext_type = (select dcry.request_type
1547: AND wif_program_code is not null;
1548:
1549: CURSOR c_transaction_wif_data IS
1550: SELECT et.transaction_subtype
1551: FROM ecx_transactions et, ecx_ext_processes ep
1552: WHERE transaction_type='DA'
1553: and ep.transaction_id = et.transaction_id
1554: and ep.direction = 'OUT'
1555: and ep.ext_type = 'WF';