DBA Data[Home] [Help]

APPS.AR_ADJVALIDATE_PVT dependencies on GL_CODE_COMBINATIONS

Line 772: FROM gl_code_combinations

768: IS
769:
770: CURSOR l_ccid_csr IS
771: SELECT code_combination_id
772: FROM gl_code_combinations
773: WHERE chart_of_accounts_id = arp_global.chart_of_accounts_id
774: AND enabled_flag = 'Y'
775: AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
776: trunc(sysdate))

Line 784: code_combination_id gl_code_combinations.code_combination_id%type

780: l_index BINARY_INTEGER default 0;
781:
782: TYPE ccid_rec IS RECORD
783: (
784: code_combination_id gl_code_combinations.code_combination_id%type
785: ) ;
786:
787: l_ccid_rec ccid_rec;
788:

Line 2438: FROM gl_code_combinations

2434:
2435: l_count := 0 ;
2436: SELECT count(*)
2437: INTO l_count
2438: FROM gl_code_combinations
2439: WHERE code_combination_id = p_adj_rec.code_combination_id
2440: AND enabled_flag = 'Y'
2441: AND SYSDATE BETWEEN NVL(start_date_active, sysdate)
2442: AND NVL(end_date_active, sysdate);