APPS.ARP_PROCESS_DET_PKG dependencies on AR_LINE_APP_DETAIL_GT

Line 1336: FROM AR_LINE_APP_DETAIL_GT b,

1332: 0))
1333: OVER (PARTITION BY b.ref_customer_trx_line_id), -- FOR ACCTD FREIGHT
1334: b.REF_CUSTOMER_TRX_LINE_ID,
1335: c.line_type
1336: FROM AR_LINE_APP_DETAIL_GT b,
1337: ra_customer_trx_lines_gt c
1338: WHERE b.gt_id = p_app_rec.gt_id
1339: AND b.app_level = p_app_rec.app_level
1340: AND b.REF_CUSTOMER_TRX_LINE_ID = c.customer_trx_line_id;

Line 1518: DELETE FROM AR_LINE_APP_DETAIL_GT

1514: WHERE gt_id = p_app_rec.gt_id
1515: AND app_level = p_app_rec.app_level;
1516:
1517: -- 4 delete the distributions created by the application
1518: DELETE FROM AR_LINE_APP_DETAIL_GT
1519: WHERE gt_id = p_app_rec.gt_id
1520: AND app_level = p_app_rec.app_level;
1521:
1522: arp_standard.debug('delete_application -');

Line 2491: UPDATE ar_line_app_detail_gt

2487: x_ra_rec.CHARGES_UEDISCOUNTED,
2488: x_ra_rec.receivable_application_id;
2489: IF c%FOUND THEN
2490: --
2491: UPDATE ar_line_app_detail_gt
2492: SET gt_id = USERENV('SESSIONID')
2493: WHERE gt_id LIKE USERENV('SESSIONID')||'%';
2494: --
2495: UPDATE ar_receivable_apps_gt

Line 2649: DELETE FROM ar_line_app_detail_gt WHERE gt_id = TO_CHAR(USERENV('SESSIONID'));

2645: g_payschedule_trx := g_payschedule_clr;
2646: g_payschedule_rec := g_payschedule_clr;
2647:
2648: DELETE FROM ra_ar_gt WHERE gt_id = TO_CHAR(USERENV('SESSIONID'));
2649: DELETE FROM ar_line_app_detail_gt WHERE gt_id = TO_CHAR(USERENV('SESSIONID'));
2650: DELETE FROM ar_receivable_apps_gt where gt_id = TO_CHAR(USERENV('SESSIONID')); /* 5438627 */
2651: DELETE FROM ar_ae_alloc_rec_gt where ae_id = TO_CHAR(USERENV('SESSIONID')); /* 5438627 */
2652:
2653: