APPS.AR_ADJVALIDATE_PUB dependencies on GL_USSGL_TRANSACTION_CODES

Line 50: Ussgl_code gl_ussgl_transaction_codes.ussgl_transaction_code%type,

46:
47:
48: TYPE Ussgl_Rec_Type IS RECORD
49: (
50: Ussgl_code gl_ussgl_transaction_codes.ussgl_transaction_code%type,
51: Ussgl_context gl_ussgl_transaction_codes.context%type
52: ) ;
53: TYPE Ussgl_Cache_Tbl_Type IS
54: TABLE OF Ussgl_Rec_Type

Line 51: Ussgl_context gl_ussgl_transaction_codes.context%type

47:
48: TYPE Ussgl_Rec_Type IS RECORD
49: (
50: Ussgl_code gl_ussgl_transaction_codes.ussgl_transaction_code%type,
51: Ussgl_context gl_ussgl_transaction_codes.context%type
52: ) ;
53: TYPE Ussgl_Cache_Tbl_Type IS
54: TABLE OF Ussgl_Rec_Type
55: INDEX BY BINARY_INTEGER;

Line 739: FROM gl_ussgl_transaction_codes

735: IS
736:
737: CURSOR l_ussgl_csr IS
738: SELECT ussgl_transaction_code,context
739: FROM gl_ussgl_transaction_codes
740: WHERE chart_of_accounts_id = arp_global.chart_of_accounts_id
741: AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
742: trunc(sysdate))
743: AND nvl(trunc(end_date_active),trunc(sysdate)) ;