APPS.ARPT_SQL_FUNC_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 443: FROM ra_customer_trx_lines

439: INTO l_temp_flag
440: FROM DUAL
441: WHERE EXISTS (
442: SELECT 'Revenue recognition has been run'
443: FROM ra_customer_trx_lines
444: WHERE customer_trx_id = p_customer_trx_id
445: AND autorule_duration_processed <> 0
446: );
447:

Line 986: FROM ra_customer_trx_lines ctl

982: SELECT DECODE( MAX(customer_trx_line_id),
983: NULL, 'N',
984: 'Y')
985: INTO l_activity_flag
986: FROM ra_customer_trx_lines ctl
987: WHERE br_ref_customer_trx_id = p_customer_trx_id;
988:
989: IF (l_activity_flag = 'Y')
990: THEN RETURN('Y');

Line 1165: FROM ra_customer_trx_lines ctl,

1161: '14', ctl.interface_line_attribute14,
1162: '15', ctl.interface_line_attribute15,
1163: NULL )
1164: INTO l_line_temp
1165: FROM ra_customer_trx_lines ctl,
1166: ra_customer_trx ct,
1167: ra_batch_sources bs
1168: WHERE bs.batch_source_id = ct.batch_source_id and
1169: ctl.customer_trx_id = ct.customer_trx_id and

Line 2617: FROM ra_customer_trx_lines

2613: BEGIN
2614:
2615: SELECT NVL(SUM(extended_amount),0)
2616: INTO l_total
2617: FROM ra_customer_trx_lines
2618: WHERE line_type = p_line_type
2619: AND customer_trx_id = p_customer_trx_id;
2620:
2621: return l_total;