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 2413: FROM gl_code_combinations

2409:
2410: l_count := 0 ;
2411: SELECT count(*)
2412: INTO l_count
2413: FROM gl_code_combinations
2414: WHERE code_combination_id = p_adj_rec.code_combination_id
2415: AND enabled_flag = 'Y'
2416: AND SYSDATE BETWEEN NVL(start_date_active, sysdate)
2417: AND NVL(end_date_active, sysdate);