APPS.GL_LEDGERS_PKG dependencies on GL_CODE_COMBINATIONS

Line 367: || ' FROM gl_code_combinations WHERE chart_of_accounts_id = :1 '

363: IF x_net_income_ccid IS NOT NULL THEN
364: BEGIN
365: v_CursorSQL :=
366: 'SELECT ' || x_bal_seg_column_name
367: || ' FROM gl_code_combinations WHERE chart_of_accounts_id = :1 '
368: || ' AND code_combination_id = :2 ';
369: EXECUTE IMMEDIATE v_CursorSQL INTO v_balancing_segment
370: USING x_chart_of_accounts_id, x_net_income_ccid;
371:

Line 599: FROM gl_code_combinations

595: -- corresponding new created ledger.
596: BEGIN
597: SELECT code_combination_id
598: INTO x_suspense_ccid_temp
599: FROM gl_code_combinations
600: WHERE code_combination_id = x_suspense_ccid;
601: EXCEPTION
602: WHEN OTHERS THEN
603: x_suspense_ccid_temp := NULL;

Line 1242: FROM gl_code_combinations

1238: -- Start the temporary Code
1239: BEGIN
1240: SELECT code_combination_id
1241: INTO x_cum_trans_ccid_temp
1242: FROM gl_code_combinations
1243: WHERE code_combination_id = x_cum_trans_ccid;
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: x_cum_trans_ccid_temp := NULL;

Line 1252: FROM gl_code_combinations

1248:
1249: BEGIN
1250: SELECT code_combination_id
1251: INTO x_res_encumb_ccid_temp
1252: FROM gl_code_combinations
1253: WHERE code_combination_id = x_res_encumb_ccid;
1254: EXCEPTION
1255: WHEN OTHERS THEN
1256: x_res_encumb_ccid_temp := NULL;

Line 1262: FROM gl_code_combinations

1258:
1259: BEGIN
1260: SELECT code_combination_id
1261: INTO x_net_income_ccid_temp
1262: FROM gl_code_combinations
1263: WHERE code_combination_id = x_net_income_ccid;
1264: EXCEPTION
1265: WHEN OTHERS THEN
1266: x_net_income_ccid_temp := NULL;

Line 1272: FROM gl_code_combinations

1268:
1269: BEGIN
1270: SELECT code_combination_id
1271: INTO x_rounding_ccid_temp
1272: FROM gl_code_combinations
1273: WHERE code_combination_id = x_rounding_ccid;
1274: EXCEPTION
1275: WHEN OTHERS THEN
1276: x_rounding_ccid_temp := NULL;

Line 1575: || ' FROM gl_code_combinations WHERE chart_of_accounts_id = :1 '

1571: IF x_net_income_ccid IS NOT NULL THEN
1572: BEGIN
1573: v_CursorSQL :=
1574: 'SELECT ' || x_bal_seg_column_name
1575: || ' FROM gl_code_combinations WHERE chart_of_accounts_id = :1 '
1576: || ' AND code_combination_id = :2 ';
1577: EXECUTE IMMEDIATE v_CursorSQL INTO v_balancing_segment
1578: USING x_chart_of_accounts_id, x_net_income_ccid;
1579: EXCEPTION

Line 1606: FROM gl_code_combinations

1602: -- flag is turned on in order to avoid inserting invalid suspense CCID
1603: BEGIN
1604: SELECT code_combination_id
1605: INTO x_suspense_ccid_temp
1606: FROM gl_code_combinations
1607: WHERE code_combination_id = x_suspense_ccid;
1608: EXCEPTION
1609: WHEN OTHERS THEN
1610: x_suspense_ccid_temp := NULL;