APPS.AR_ADJVALIDATE_PVT dependencies on GL_USSGL_TRANSACTION_CODES

Line 60: Ussgl_code gl_ussgl_transaction_codes.ussgl_transaction_code%type,

56:
57:
58: TYPE Ussgl_Rec_Type IS RECORD
59: (
60: Ussgl_code gl_ussgl_transaction_codes.ussgl_transaction_code%type,
61: Ussgl_context gl_ussgl_transaction_codes.context%type
62: ) ;
63: TYPE Ussgl_Cache_Tbl_Type IS
64: TABLE OF Ussgl_Rec_Type

Line 61: Ussgl_context gl_ussgl_transaction_codes.context%type

57:
58: TYPE Ussgl_Rec_Type IS RECORD
59: (
60: Ussgl_code gl_ussgl_transaction_codes.ussgl_transaction_code%type,
61: Ussgl_context gl_ussgl_transaction_codes.context%type
62: ) ;
63: TYPE Ussgl_Cache_Tbl_Type IS
64: TABLE OF Ussgl_Rec_Type
65: INDEX BY BINARY_INTEGER;

Line 678: FROM gl_ussgl_transaction_codes

674: IS
675:
676: CURSOR l_ussgl_csr IS
677: SELECT ussgl_transaction_code,context
678: FROM gl_ussgl_transaction_codes
679: WHERE chart_of_accounts_id = arp_global.chart_of_accounts_id
680: AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
681: trunc(sysdate))
682: AND nvl(trunc(end_date_active),trunc(sysdate)) ;