DBA Data[Home] [Help]

APPS.AR_ADJVALIDATE_PUB dependencies on GL_CODE_COMBINATIONS

Line 834: FROM gl_code_combinations

830: IS
831:
832: CURSOR l_ccid_csr IS
833: SELECT code_combination_id
834: FROM gl_code_combinations
835: WHERE chart_of_accounts_id = arp_global.chart_of_accounts_id
836: AND enabled_flag = 'Y'
837: AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
838: trunc(sysdate))

Line 846: code_combination_id gl_code_combinations.code_combination_id%type

842: l_index BINARY_INTEGER default 0;
843:
844: TYPE ccid_rec IS RECORD
845: (
846: code_combination_id gl_code_combinations.code_combination_id%type
847: ) ;
848:
849: l_ccid_rec ccid_rec;
850:

Line 2016: FROM gl_code_combinations

2012:
2013: l_count := 0 ;
2014: SELECT count(*)
2015: INTO l_count
2016: FROM gl_code_combinations
2017: WHERE code_combination_id = p_adj_rec.code_combination_id
2018: AND enabled_flag = 'Y'
2019: AND SYSDATE BETWEEN NVL(start_date_active, sysdate)
2020: AND NVL(end_date_active, sysdate);