[Home] [Help]
2184: AND NOT EXISTS
2185: (SELECT br_ref_payment_schedule_id
2186: from
2187: ra_customer_trx_lines br_lines,
2188: ar_transaction_history th
2189: where br_lines.br_ref_payment_schedule_id = ps.payment_schedule_id
2190: and br_lines.customer_trx_id = th.customer_trx_id
2191: and th.current_record_flag = ''Y''
2192: and th.status <> ''CANCELLED'') /*Bug2290332*/
2788: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
2789:
2790: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2791: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;
2792: l_bill_status AR_TRANSACTION_HISTORY.status%TYPE;
2793: l_request_id NUMBER;
2794:
2795: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;
2796: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
3713: end if;
3714:
3715:
3716: select org_id into jnk1 from ra_customer_trx where customer_trx_id = l_bill_id;
3717: select org_id into jnk2 from ar_transaction_history where customer_trx_id = l_bill_id;
3718:
3719: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Header org_id = ' || to_char(jnk1) || 'org_id = ' ||
3720: to_char(jnk2));
3721:
4989: 'AND ps.payment_schedule_id NOT IN '||
4990: '(SELECT br_ref_payment_schedule_id '||
4991: ' from '||
4992: 'ra_customer_trx_lines br_lines, '||
4993: 'ar_transaction_history th '||
4994: 'where br_lines.br_ref_payment_schedule_id = ps.payment_schedule_id '||
4995: 'and br_lines.customer_trx_id = th.customer_trx_id '||
4996: 'and th.current_record_flag = ''Y'' '||
4997: 'and th.status <> ''CANCELLED'') '||