APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_TRANSACTION_HISTORY

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

434:
435: /*-------------------------------------------------------+
436: | 04-AUG-2000 J Rautiainen BR Implementation |
437: | For Bills Receivable check the posting from table |
438: | ar_transaction_history, for other types use the |
439: | existing logic. |
440: +-------------------------------------------------------*/
441: IF (p_class = 'BR' )THEN
442:

Line 450: FROM ar_transaction_history

446: INTO l_temp_flag
447: FROM DUAL
448: WHERE EXISTS (
449: SELECT 'transaction has been posted'
450: FROM ar_transaction_history
451: WHERE customer_trx_id = p_customer_trx_id
452: AND gl_posted_date IS NOT NULL
453: );
454:

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

926:
927: /*-------------------------------------------------------+
928: | 04-AUG-2000 J Rautiainen BR Implementation |
929: | For Bills Receivable check the posting from table |
930: | ar_transaction_history, for other types use the |
931: | existing logic. |
932: +-------------------------------------------------------*/
933:
934: IF (p_class = 'BR' ) THEN

Line 938: FROM ar_transaction_history

934: IF (p_class = 'BR' ) THEN
935:
936: SELECT DECODE( MAX( gl_posted_date ), NULL, 'N', 'Y')
937: INTO l_activity_flag
938: FROM ar_transaction_history
939: WHERE customer_trx_id = p_customer_trx_id;
940:
941: ELSE
942:

Line 2464: FROM ar_transaction_history h

2460: BEGIN
2461:
2462: SELECT gl_date
2463: INTO l_orig_gl_date
2464: FROM ar_transaction_history h
2465: WHERE h.customer_trx_id = p_customer_trx_id
2466: AND h.event in ('COMPLETED','ACCEPTED')
2467: AND h.transaction_history_id =
2468: (SELECT max(transaction_history_id)

Line 2469: FROM ar_transaction_history h2

2465: WHERE h.customer_trx_id = p_customer_trx_id
2466: AND h.event in ('COMPLETED','ACCEPTED')
2467: AND h.transaction_history_id =
2468: (SELECT max(transaction_history_id)
2469: FROM ar_transaction_history h2
2470: WHERE h2.customer_trx_id = p_customer_trx_id
2471: AND h2.event IN ('COMPLETED','ACCEPTED'));
2472:
2473: return l_orig_gl_date;

Line 2480: FROM ar_transaction_history h

2476: WHEN NO_DATA_FOUND THEN
2477:
2478: SELECT gl_date
2479: INTO l_orig_gl_date
2480: FROM ar_transaction_history h
2481: WHERE h.customer_trx_id = p_customer_trx_id
2482: AND h.current_record_flag = 'Y';
2483:
2484: return l_orig_gl_date;