APPS.ARP_RATE_ADJ dependencies on RA_CUSTOMER_TRX

Line 262: FROM ra_customer_trx

258:
259: --BUG#5022786
260: CURSOR c_trx(p_trx_id IN NUMBER) IS
261: SELECT upgrade_method
262: FROM ra_customer_trx
263: WHERE customer_trx_id = p_trx_id;
264:
265: l_gt_id NUMBER;
266: x_return_status VARCHAR2(10);

Line 327: FROM ra_customer_trx_lines_gt

323: CURSOR c_trx_gt(p_customer_trx_id IN NUMBER)
324: IS
325: SELECT COUNT(CUSTOMER_TRX_LINE_ID),
326: CUSTOMER_TRX_LINE_ID
327: FROM ra_customer_trx_lines_gt
328: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
329: GROUP BY CUSTOMER_TRX_LINE_ID;
330:
331: l_cnt_line DBMS_SQL.NUMBER_TABLE;

Line 348: FROM ra_customer_trx_lines

344: FRT_ED_AMOUNT ,
345: FRT_UNED_ACCTD_AMOUNT ,
346: FRT_UNED_AMOUNT ,
347: customer_trx_line_id
348: FROM ra_customer_trx_lines
349: WHERE customer_trx_id = p_customer_trx_id;
350:
351: l_ACCTD_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
352: l_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;

Line 1599: ra_customer_trx trx

1595: ,trx.invoice_currency_code -- TO_CURRENCY
1596: ,'' -- REF_MF_DIST_FLAG
1597: FROM ar_distributions ard,
1598: ar_receivable_applications ora,
1599: ra_customer_trx trx
1600: WHERE ora.receivable_application_id = old_rec_app.receivable_application_id
1601: AND ard.source_table = 'RA'
1602: AND ard.source_id = ora.receivable_application_id
1603: AND ard.activity_bucket IS NOT NULL

Line 2057: ra_customer_trx trx

2053: ,trx.invoice_currency_code -- TO_CURRENCY
2054: ,'' -- REF_MF_DIST_FLAG
2055: FROM ar_distributions ard,
2056: ar_receivable_applications ora,
2057: ra_customer_trx trx
2058: WHERE ora.receivable_application_id = old_rec_app.receivable_application_id
2059: AND ard.source_table = 'RA'
2060: AND ard.source_id = ora.receivable_application_id
2061: AND ard.activity_bucket IS NOT NULL

Line 2073: UPDATE ra_customer_trx_lines SET

2069:
2070:
2071: IF l_reset_rem = 'Y' THEN
2072: FORALL i IN l_customer_trx_line_id.FIRST ..l_customer_trx_line_id.LAST
2073: UPDATE ra_customer_trx_lines SET
2074: ACCTD_AMOUNT_DUE_REMAINING = l_ACCTD_AMOUNT_DUE_REMAINING(i),
2075: AMOUNT_DUE_REMAINING = l_AMOUNT_DUE_REMAINING(i),
2076: CHRG_ACCTD_AMOUNT_REMAINING= l_CHRG_ACCTD_AMOUNT_REMAINING(i),
2077: CHRG_AMOUNT_REMAINING = l_CHRG_AMOUNT_REMAINING(i),