APPS.ARPT_SQL_FUNC_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 375: FROM ra_customer_trx_lines

371: INTO l_temp_flag
372: FROM DUAL
373: WHERE EXISTS (
374: SELECT 'Revenue recognition has been run'
375: FROM ra_customer_trx_lines
376: WHERE customer_trx_id = p_customer_trx_id
377: AND autorule_duration_processed <> 0
378: );
379:

Line 918: FROM ra_customer_trx_lines ctl

914: SELECT DECODE( MAX(customer_trx_line_id),
915: NULL, 'N',
916: 'Y')
917: INTO l_activity_flag
918: FROM ra_customer_trx_lines ctl
919: WHERE br_ref_customer_trx_id = p_customer_trx_id;
920:
921: IF (l_activity_flag = 'Y')
922: THEN RETURN('Y');

Line 1097: FROM ra_customer_trx_lines ctl,

1093: '14', ctl.interface_line_attribute14,
1094: '15', ctl.interface_line_attribute15,
1095: NULL )
1096: INTO l_line_temp
1097: FROM ra_customer_trx_lines ctl,
1098: ra_customer_trx ct,
1099: ra_batch_sources bs
1100: WHERE bs.batch_source_id = ct.batch_source_id and
1101: ctl.customer_trx_id = ct.customer_trx_id and

Line 2498: FROM ra_customer_trx_lines

2494: BEGIN
2495:
2496: SELECT NVL(SUM(extended_amount),0)
2497: INTO l_total
2498: FROM ra_customer_trx_lines
2499: WHERE line_type = p_line_type
2500: AND customer_trx_id = p_customer_trx_id;
2501:
2502: return l_total;