[Home] [Help]
2043: AND NOT EXISTS
2044: (SELECT br_ref_payment_schedule_id
2045: from
2046: ra_customer_trx_lines br_lines,
2047: ar_transaction_history th
2048: where br_lines.br_ref_payment_schedule_id = ps.payment_schedule_id
2049: and br_lines.customer_trx_id = th.customer_trx_id
2050: and th.current_record_flag = ''Y''
2051: and th.status <> ''CANCELLED'') /*Bug2290332*/
2647: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
2648:
2649: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2650: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;
2651: l_bill_status AR_TRANSACTION_HISTORY.status%TYPE;
2652: l_request_id NUMBER;
2653:
2654: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;
2655: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
3554: end if;
3555:
3556:
3557: select org_id into jnk1 from ra_customer_trx where customer_trx_id = l_bill_id;
3558: select org_id into jnk2 from ar_transaction_history where customer_trx_id = l_bill_id;
3559:
3560: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Header org_id = ' || to_char(jnk1) || 'org_id = ' ||
3561: to_char(jnk2));
3562:
4830: 'AND ps.payment_schedule_id NOT IN '||
4831: '(SELECT br_ref_payment_schedule_id '||
4832: ' from '||
4833: 'ra_customer_trx_lines br_lines, '||
4834: 'ar_transaction_history th '||
4835: 'where br_lines.br_ref_payment_schedule_id = ps.payment_schedule_id '||
4836: 'and br_lines.customer_trx_id = th.customer_trx_id '||
4837: 'and th.current_record_flag = ''Y'' '||
4838: 'and th.status <> ''CANCELLED'') '||