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 3698: debug(' deletion from cst_reconciliation_summary');

3694:
3695: /* Update the summary table now for each po_dist_id. First delete the current info from the table
3696: and then update it with the latest data */
3697:
3698: debug(' deletion from cst_reconciliation_summary');
3699:
3700: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3701: DELETE from cst_reconciliation_summary crs
3702: WHERE crs.operating_unit_id = p_operating_unit

Line 3701: DELETE from cst_reconciliation_summary crs

3697:
3698: debug(' deletion from cst_reconciliation_summary');
3699:
3700: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3701: DELETE from cst_reconciliation_summary crs
3702: WHERE crs.operating_unit_id = p_operating_unit
3703: AND crs.po_distribution_id = po_dists_tab(indx);
3704:
3705: debug(' Done Deleting from CRS');

Line 3718: Insert into CST_RECONCILIATION_SUMMARY

3714: debug(' populating CRS from cst_reconciliation_gtt');
3715:
3716: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3717:
3718: Insert into CST_RECONCILIATION_SUMMARY
3719: (
3720: po_distribution_id,
3721: accrual_account_id,
3722: po_balance,

Line 3928: FROM cst_reconciliation_summary crs

3924: WHERE gtt.operating_unit_id = p_operating_unit
3925: AND gtt.po_distribution_id = po_dists_tab(indx)
3926: AND EXISTS (
3927: SELECT 1
3928: FROM cst_reconciliation_summary crs
3929: WHERE crs.operating_unit_id = p_operating_unit
3930: AND crs.po_distribution_id = gtt.po_distribution_id
3931: AND crs.accrual_account_id = gtt.accrual_account_id
3932: );