722: '||l_source_type_where||'
723: '||l_posting_status_where||'
724: order by company, category, account,adj_gl_date, adjustment_number' ;
725:
726: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
727: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
728:
729: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
730: BEGIN
1315: '||l_account_where ||'
1316: '||l_account_seg_where ||'
1317: '||l_posting_status_ard_where;
1318:
1319: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
1320: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
1321:
1322: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1323: BEGIN
1835: '||l_account_seg_where ||'
1836: '||l_source_type_where||'
1837: '||l_posting_status_where;
1838:
1839: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
1840: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
1841:
1842: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1843: BEGIN
2307: '||l_source_type_where||'
2308: '||l_posting_status_where||'
2309: order by company, category, account,app_gl_date, cm_number' ;
2310:
2311: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
2312: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
2313:
2314: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
2315: BEGIN
3016: ar_calc_aging.get_value(101,''GL#'',
3017: arp_recon_rep.get_chart_of_accounts_id(),
3018: ''GL_ACCOUNT'',code_combination_id)';
3019:
3020: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
3021: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
3022:
3023: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
3024: BEGIN