APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_TRANSACTION_HISTORY

Line 506: | ar_transaction_history, for other types use the |

502:
503: /*-------------------------------------------------------+
504: | 04-AUG-2000 J Rautiainen BR Implementation |
505: | For Bills Receivable check the posting from table |
506: | ar_transaction_history, for other types use the |
507: | existing logic. |
508: +-------------------------------------------------------*/
509: IF (p_class = 'BR' )THEN
510:

Line 518: FROM ar_transaction_history

514: INTO l_temp_flag
515: FROM DUAL
516: WHERE EXISTS (
517: SELECT 'transaction has been posted'
518: FROM ar_transaction_history
519: WHERE customer_trx_id = p_customer_trx_id
520: AND gl_posted_date IS NOT NULL
521: );
522:

Line 998: | ar_transaction_history, for other types use the |

994:
995: /*-------------------------------------------------------+
996: | 04-AUG-2000 J Rautiainen BR Implementation |
997: | For Bills Receivable check the posting from table |
998: | ar_transaction_history, for other types use the |
999: | existing logic. |
1000: +-------------------------------------------------------*/
1001:
1002: IF (p_class = 'BR' ) THEN

Line 1006: FROM ar_transaction_history

1002: IF (p_class = 'BR' ) THEN
1003:
1004: SELECT DECODE( MAX( gl_posted_date ), NULL, 'N', 'Y')
1005: INTO l_activity_flag
1006: FROM ar_transaction_history
1007: WHERE customer_trx_id = p_customer_trx_id;
1008:
1009: ELSE
1010:

Line 2583: FROM ar_transaction_history h

2579: BEGIN
2580:
2581: SELECT gl_date
2582: INTO l_orig_gl_date
2583: FROM ar_transaction_history h
2584: WHERE h.customer_trx_id = p_customer_trx_id
2585: AND h.event in ('COMPLETED','ACCEPTED')
2586: AND h.transaction_history_id =
2587: (SELECT max(transaction_history_id)

Line 2588: FROM ar_transaction_history h2

2584: WHERE h.customer_trx_id = p_customer_trx_id
2585: AND h.event in ('COMPLETED','ACCEPTED')
2586: AND h.transaction_history_id =
2587: (SELECT max(transaction_history_id)
2588: FROM ar_transaction_history h2
2589: WHERE h2.customer_trx_id = p_customer_trx_id
2590: AND h2.event IN ('COMPLETED','ACCEPTED'));
2591:
2592: return l_orig_gl_date;

Line 2599: FROM ar_transaction_history h

2595: WHEN NO_DATA_FOUND THEN
2596:
2597: SELECT gl_date
2598: INTO l_orig_gl_date
2599: FROM ar_transaction_history h
2600: WHERE h.customer_trx_id = p_customer_trx_id
2601: AND h.current_record_flag = 'Y';
2602:
2603: return l_orig_gl_date;