[Home] [Help]
2050: /* Bug 3922691 :
2051: - replace trx.trx_date with ps.trx_date
2052: - replace (ps.due_date - pm.lead_days) <= SYSDATE
2053: with ps.due_date <= SYSDATE + pm.lead_days
2054: - use NOT EXISTS in check against ra_customer_trx_lines
2055: - remove join to hz_cust_acct_sites, this is done in construct_hz
2056: */
2057: /* Bug 4928711 - Removed the references to ap_bank_accounts */
2058:
2183: and nvl(extn.instrument_id,-1) = decode(:p_customer_bank_account_id,-999, nvl(extn.instrument_id,-1),nvl(:p_customer_bank_account_id,-1))
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''
2784: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2785: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2786:
2787:
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;
3796: NULL, -- p_attribute15
3797: l_org_id, -- p_org_id
3798: l_customer_trx_line_id);
3799:
3800: select org_id into jnk1 from ra_customer_trx_lines where customer_trx_line_id = l_customer_trx_line_id;
3801: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM, org_id = '
3802: || to_char(jnk1));
3803:
3804: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
4988: 'AND ps.customer_trx_id = NVL(:p_customer_trx_id,ps.customer_trx_id) '||
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'' '||