DBA Data[Home] [Help]

APPS.PSB_WS_ACCT2 dependencies on GL_CODE_COMBINATIONS

Line 895: --FROM PSB_BUDGET_ACCOUNTS a, GL_CODE_COMBINATIONS b

891:
892: -- for bug 4256345
893: --CURSOR c_ccids (AccSetID NUMBER) is
894: --SELECT a.code_combination_id, b.start_date_active, b.end_date_active
895: --FROM PSB_BUDGET_ACCOUNTS a, GL_CODE_COMBINATIONS b
896: --WHERE a.account_position_set_id = AccSetID
897: /* Bug 3692601 Start */
898: --AND b.detail_budgeting_allowed_flag = 'Y'
899: /* Bug 3692601 End */

Line 1149: FROM gl_code_combinations

1145: /* start bug 4256345 */
1146: BEGIN
1147: SELECT 'TRUE', start_date_active, end_date_active
1148: INTO lt_valid_ccid, lt_start_date_active, lt_end_date_active
1149: FROM gl_code_combinations
1150: WHERE code_combination_id = l_ccids.ccid(l_ccid_index)
1151: AND enabled_flag = 'Y'
1152: AND detail_budgeting_allowed_flag = 'Y';
1153: EXCEPTION

Line 1180: GL_CODE_COMBINATIONS_PKG.Select_Columns

1176:
1177: g_actuals_func_total := 0;
1178: g_actuals_stat_total := 0;
1179:
1180: GL_CODE_COMBINATIONS_PKG.Select_Columns
1181: ( X_code_combination_id => l_ccids.ccid(l_ccid_index) ,
1182: X_account_type => l_account_type ,
1183: X_template_id => l_template_id ) ;
1184:

Line 2500: gl_code_combinations b

2496: CURSOR c_ccids ( c_account_set_id NUMBER)
2497: IS
2498: SELECT a.code_combination_id, b.start_date_active, b.end_date_active
2499: FROM psb_budget_accounts a,
2500: gl_code_combinations b
2501: WHERE a.account_position_set_id = c_account_set_id
2502: /* Bug 3692601 Start */
2503: AND b.detail_budgeting_allowed_flag = 'Y'
2504: /* Bug 3692601 End */

Line 2875: GL_CODE_COMBINATIONS_PKG.Select_Columns

2871:
2872: g_actuals_func_total := 0;
2873: g_actuals_stat_total := 0;
2874:
2875: GL_CODE_COMBINATIONS_PKG.Select_Columns
2876: ( X_code_combination_id => l_ccids.ccid(l_ccid_index) ,
2877: X_account_type => l_account_type ,
2878: X_template_id => l_template_id ) ;
2879: