eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_ACCRUAL_LOAD dependencies on CST_RECONCILIATION_SUMMARY

Line 4069: debug(' deletion from cst_reconciliation_summary');

4065:
4066: /* Update the summary table now for each po_dist_id. First delete the current info from the table
4067: and then update it with the latest data */
4068:
4069: debug(' deletion from cst_reconciliation_summary');
4070:
4071: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
4072: DELETE from cst_reconciliation_summary crs
4073: WHERE crs.operating_unit_id = p_operating_unit

Line 4072: DELETE from cst_reconciliation_summary crs

4068:
4069: debug(' deletion from cst_reconciliation_summary');
4070:
4071: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
4072: DELETE from cst_reconciliation_summary crs
4073: WHERE crs.operating_unit_id = p_operating_unit
4074: AND crs.po_distribution_id = po_dists_tab(indx);
4075:
4076: debug(' Done Deleting from CRS');

Line 4089: Insert into CST_RECONCILIATION_SUMMARY

4085: debug(' populating CRS from cst_reconciliation_gtt');
4086:
4087: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
4088:
4089: Insert into CST_RECONCILIATION_SUMMARY
4090: (
4091: po_distribution_id,
4092: accrual_account_id,
4093: po_balance,

Line 4299: FROM cst_reconciliation_summary crs

4295: WHERE gtt.operating_unit_id = p_operating_unit
4296: AND gtt.po_distribution_id = po_dists_tab(indx)
4297: AND EXISTS (
4298: SELECT 1
4299: FROM cst_reconciliation_summary crs
4300: WHERE crs.operating_unit_id = p_operating_unit
4301: AND crs.po_distribution_id = gtt.po_distribution_id
4302: AND crs.accrual_account_id = gtt.accrual_account_id
4303: );