DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on CST_AP_PO_RECONCILIATION

Line 3847: debug(' deleting into cst_ap_po_reconciliation');

3843:
3844: /* Delete all transactions details from the AP/PO details table for those rows that belong to
3845: the current po_dist_id */
3846:
3847: debug(' deleting into cst_ap_po_reconciliation');
3848:
3849: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3850: DELETE from cst_ap_po_reconciliation capr
3851: WHERE capr.operating_unit_id = p_operating_unit

Line 3850: DELETE from cst_ap_po_reconciliation capr

3846:
3847: debug(' deleting into cst_ap_po_reconciliation');
3848:
3849: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3850: DELETE from cst_ap_po_reconciliation capr
3851: WHERE capr.operating_unit_id = p_operating_unit
3852: AND capr.po_distribution_id = po_dists_tab(indx);
3853:
3854: debug(' Done Deleting old data from CAPR');

Line 3860: debug(' deleting into cst_ap_po_reconciliation');

3856: l_stmt_num := 90;
3857:
3858: /* insert into AP/PO table from GTT */
3859:
3860: debug(' deleting into cst_ap_po_reconciliation');
3861:
3862: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3863: Insert into CST_AP_PO_RECONCILIATION
3864: (

Line 3863: Insert into CST_AP_PO_RECONCILIATION

3859:
3860: debug(' deleting into cst_ap_po_reconciliation');
3861:
3862: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3863: Insert into CST_AP_PO_RECONCILIATION
3864: (
3865: transaction_date,
3866: amount,
3867: entered_amount,