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 323: FROM ra_customer_trx_lines_gt

319: CURSOR c_trx_gt(p_customer_trx_id IN NUMBER)
320: IS
321: SELECT COUNT(CUSTOMER_TRX_LINE_ID),
322: CUSTOMER_TRX_LINE_ID
323: FROM ra_customer_trx_lines_gt
324: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
325: GROUP BY CUSTOMER_TRX_LINE_ID;
326:
327: l_cnt_line DBMS_SQL.NUMBER_TABLE;

Line 344: FROM ra_customer_trx_lines

340: FRT_ED_AMOUNT ,
341: FRT_UNED_ACCTD_AMOUNT ,
342: FRT_UNED_AMOUNT ,
343: customer_trx_line_id
344: FROM ra_customer_trx_lines
345: WHERE customer_trx_id = p_customer_trx_id;
346:
347: l_ACCTD_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
348: l_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;

Line 1540: ra_customer_trx trx

1536: ,trx.invoice_currency_code -- TO_CURRENCY
1537: ,'' -- REF_MF_DIST_FLAG
1538: FROM ar_distributions ard,
1539: ar_receivable_applications ora,
1540: ra_customer_trx trx
1541: WHERE ora.receivable_application_id = old_rec_app.receivable_application_id
1542: AND ard.source_table = 'RA'
1543: AND ard.source_id = ora.receivable_application_id
1544: AND ard.activity_bucket IS NOT NULL

Line 1981: ra_customer_trx trx

1977: ,trx.invoice_currency_code -- TO_CURRENCY
1978: ,'' -- REF_MF_DIST_FLAG
1979: FROM ar_distributions ard,
1980: ar_receivable_applications ora,
1981: ra_customer_trx trx
1982: WHERE ora.receivable_application_id = old_rec_app.receivable_application_id
1983: AND ard.source_table = 'RA'
1984: AND ard.source_id = ora.receivable_application_id
1985: AND ard.activity_bucket IS NOT NULL

Line 1997: UPDATE ra_customer_trx_lines SET

1993:
1994:
1995: IF l_reset_rem = 'Y' THEN
1996: FORALL i IN l_customer_trx_line_id.FIRST ..l_customer_trx_line_id.LAST
1997: UPDATE ra_customer_trx_lines SET
1998: ACCTD_AMOUNT_DUE_REMAINING = l_ACCTD_AMOUNT_DUE_REMAINING(i),
1999: AMOUNT_DUE_REMAINING = l_AMOUNT_DUE_REMAINING(i),
2000: CHRG_ACCTD_AMOUNT_REMAINING= l_CHRG_ACCTD_AMOUNT_REMAINING(i),
2001: CHRG_AMOUNT_REMAINING = l_CHRG_AMOUNT_REMAINING(i),