[Home] [Help]
2062: from hz_cust_accounts hzca, fv_finance_charge_controls fcc
2063: where fcc.enabled_flag = 'Y'
2064: and fcc.set_of_books_id = sob_id
2065: and hzca.status = 'A'
2066: and exists (select 'x' from fv_cust_finance_chrgs
2067: where hzca.cust_account_id = customer_id
2068: and fcc.charge_id = charge_id
2069: and set_of_books_id = sob_id)
2070: and not exists (select 'x' from fv_finance_chrg_cust_classes
2101: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2102: 'Updating waive flag for: '||customer.customer_id);
2103: END IF;
2104:
2105: update fv_cust_finance_chrgs
2106: set waive_flag = 'Y'
2107: where customer_id = customer.customer_id
2108: and charge_id not in
2109: (select charge_id from fv_finance_chrg_cust_classes, hz_cust_Accounts hzca
2116:
2117: end;
2118:
2119: -- End addition
2120: insert into fv_cust_finance_chrgs (customer_id, charge_id, waive_flag,
2121: created_by, creation_date, last_updated_by, last_update_date,
2122: set_of_books_id,org_id)
2123: select hzca.cust_Account_id, fcc.charge_id, 'N', 0, assign_date, 0, sysdate, sob_id,
2124: fcc.org_id
2125: from hz_cust_accounts hzca, fv_finance_charge_controls fcc
2126: where fcc.enabled_flag = 'Y'
2127: and fcc.set_of_books_id = sob_id
2128: and hzca.status = 'A'
2129: and not exists (select 'x' from fv_cust_finance_chrgs
2130: where hzca.cust_account_id = customer_id
2131: and fcc.charge_id = charge_id
2132: and set_of_books_id = sob_id)
2133: and exists (select 'x' from fv_finance_chrg_cust_classes
2143: creation_date,last_updated_by, last_update_date, set_of_books_id,org_id)
2144: select ract.bill_to_customer_id, ract.customer_trx_id, fcfc.charge_id,
2145: fcfc.waive_flag, 0 , assign_date, 0 , sysdate, sob_id, v_org_id
2146: from ra_customer_trx ract,
2147: fv_cust_finance_chrgs fcfc,
2148: fv_finance_charge_controls fcc,
2149: ra_cust_trx_types rctt
2150: where ract.bill_to_customer_id = fcfc.customer_id
2151: and fcfc.set_of_books_id = sob_id