APPS.GL_LEDGERS_PKG dependencies on GL_CODE_COMBINATIONS

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

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

Line 602: FROM gl_code_combinations

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

Line 1247: FROM gl_code_combinations

1243: -- Start the temporary Code
1244: BEGIN
1245: SELECT code_combination_id
1246: INTO x_cum_trans_ccid_temp
1247: FROM gl_code_combinations
1248: WHERE code_combination_id = x_cum_trans_ccid;
1249: EXCEPTION
1250: WHEN OTHERS THEN
1251: x_cum_trans_ccid_temp := NULL;

Line 1257: FROM gl_code_combinations

1253:
1254: BEGIN
1255: SELECT code_combination_id
1256: INTO x_res_encumb_ccid_temp
1257: FROM gl_code_combinations
1258: WHERE code_combination_id = x_res_encumb_ccid;
1259: EXCEPTION
1260: WHEN OTHERS THEN
1261: x_res_encumb_ccid_temp := NULL;

Line 1267: FROM gl_code_combinations

1263:
1264: BEGIN
1265: SELECT code_combination_id
1266: INTO x_net_income_ccid_temp
1267: FROM gl_code_combinations
1268: WHERE code_combination_id = x_net_income_ccid;
1269: EXCEPTION
1270: WHEN OTHERS THEN
1271: x_net_income_ccid_temp := NULL;

Line 1277: FROM gl_code_combinations

1273:
1274: BEGIN
1275: SELECT code_combination_id
1276: INTO x_rounding_ccid_temp
1277: FROM gl_code_combinations
1278: WHERE code_combination_id = x_rounding_ccid;
1279: EXCEPTION
1280: WHEN OTHERS THEN
1281: x_rounding_ccid_temp := NULL;

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

1578: IF x_net_income_ccid IS NOT NULL THEN
1579: BEGIN
1580: v_CursorSQL :=
1581: 'SELECT ' || x_bal_seg_column_name
1582: || ' FROM gl_code_combinations WHERE chart_of_accounts_id = :1 '
1583: || ' AND code_combination_id = :2 ';
1584: EXECUTE IMMEDIATE v_CursorSQL INTO v_balancing_segment
1585: USING x_chart_of_accounts_id, x_net_income_ccid;
1586: EXCEPTION

Line 1613: FROM gl_code_combinations

1609: -- flag is turned on in order to avoid inserting invalid suspense CCID
1610: BEGIN
1611: SELECT code_combination_id
1612: INTO x_suspense_ccid_temp
1613: FROM gl_code_combinations
1614: WHERE code_combination_id = x_suspense_ccid;
1615: EXCEPTION
1616: WHEN OTHERS THEN
1617: x_suspense_ccid_temp := NULL;