APPS.ARP_PROCESS_DET_PKG dependencies on AR_LINE_APP_DETAIL_GT

Line 1334: FROM AR_LINE_APP_DETAIL_GT b,

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

Line 1516: DELETE FROM AR_LINE_APP_DETAIL_GT

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

Line 2430: UPDATE ar_line_app_detail_gt

2426: x_ra_rec.CHARGES_UEDISCOUNTED,
2427: x_ra_rec.receivable_application_id;
2428: IF c%FOUND THEN
2429: --
2430: UPDATE ar_line_app_detail_gt
2431: SET gt_id = USERENV('SESSIONID')
2432: WHERE gt_id LIKE USERENV('SESSIONID')||'%';
2433: --
2434: UPDATE ar_receivable_apps_gt

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

2583: g_payschedule_trx := g_payschedule_clr;
2584: g_payschedule_rec := g_payschedule_clr;
2585:
2586: DELETE FROM ra_ar_gt WHERE gt_id = TO_CHAR(USERENV('SESSIONID'));
2587: DELETE FROM ar_line_app_detail_gt WHERE gt_id = TO_CHAR(USERENV('SESSIONID'));
2588: DELETE FROM ar_receivable_apps_gt where gt_id = TO_CHAR(USERENV('SESSIONID')); /* 5438627 */
2589: DELETE FROM ar_ae_alloc_rec_gt where ae_id = TO_CHAR(USERENV('SESSIONID')); /* 5438627 */
2590:
2591: