APPS.PSB_BUDGET_REVISIONS_PVT dependencies on GL_CODE_COMBINATIONS

Line 1109: GL_CODE_COMBINATIONS_PKG.Select_Columns

1105: if l_budget_revision_acct_line_id is null then
1106: begin
1107:
1108: -- Create new entries for all cases other than revise projections
1109: GL_CODE_COMBINATIONS_PKG.Select_Columns
1110: (X_code_combination_id => p_code_combination_id,
1111: X_account_type => l_account_type,
1112: X_template_id => l_template_id);
1113:

Line 1725: GL_CODE_COMBINATIONS_PKG.Select_Columns

1721: for c_lines_rec in c_lines loop
1722:
1723: l_budget_revision_acct_line_id := NULL;
1724:
1725: GL_CODE_COMBINATIONS_PKG.Select_Columns
1726: (X_code_combination_id => c_lines_rec.code_combination_id,
1727: X_account_type => l_account_type,
1728: X_template_id => l_template_id);
1729:

Line 1892: -- Fetch the account type from Gl_Code_Combinations table.

1888: l_budget_group_id := c_Root_Budget_Group_Rec.root_budget_group_id;
1889: End Loop;
1890:
1891: /* Start Bug 3687997 */
1892: -- Fetch the account type from Gl_Code_Combinations table.
1893: FOR l_account_type_csr IN
1894: (SELECT account_type
1895: FROM gl_code_combinations
1896: WHERE code_combination_id = p_code_combination_id)

Line 1895: FROM gl_code_combinations

1891: /* Start Bug 3687997 */
1892: -- Fetch the account type from Gl_Code_Combinations table.
1893: FOR l_account_type_csr IN
1894: (SELECT account_type
1895: FROM gl_code_combinations
1896: WHERE code_combination_id = p_code_combination_id)
1897: LOOP
1898: l_account_type := l_account_type_csr.account_type;
1899: END LOOP;

Line 2268: GL_CODE_COMBINATIONS_PKG.Select_Columns

2264: FOR l_indx IN 1..l_rev_lines_tab_inst.COUNT LOOP
2265: l_entered_dr := NULL;
2266: l_entered_cr := NULL;
2267:
2268: GL_CODE_COMBINATIONS_PKG.Select_Columns
2269: (X_code_combination_id => l_rev_lines_tab_inst(l_indx).code_combination_id,
2270: X_account_type => l_account_type,
2271: X_template_id => l_template_id
2272: );

Line 2469: FROM gl_code_combinations

2465:
2466: /*For Bug No : 2925078 Start*/
2467: CURSOR C_Account_Type IS
2468: SELECT account_type
2469: FROM gl_code_combinations
2470: WHERE code_combination_id = p_code_combination_id;
2471: l_account_type VARCHAR2(1);
2472: /*For Bug No : 2925078 End*/
2473:

Line 11041: FROM GL_CODE_COMBINATIONS_KFV

11037: --Pls. do not change the formatted new line characters below.
11038: --as AD coding standards doesn't allow chr(10), it has been changed
11039: FOR l_index IN 1..g_no_ccids LOOP
11040: SELECT concatenated_segments INTO l_con_segments
11041: FROM GL_CODE_COMBINATIONS_KFV
11042: WHERE code_combination_id = g_ccid_rec(l_index).ccid;
11043: IF (NVL(g_ccid_rec(l_index).apply_balance_flag,'A') = 'A') THEN
11044: l_apply_message := l_apply_message||fnd_global.local_chr(10)||l_con_segments;
11045: ELSIF (g_ccid_rec(l_index).apply_balance_flag = 'B') THEN

Line 11256: ' FROM gl_code_combinations glcc,'||

11252:
11253: ELSIF (p_application_column_name IS NOT NULL) THEN
11254:
11255: l_seg_sql := 'SELECT DISTINCT glcc.'||p_application_column_name||
11256: ' FROM gl_code_combinations glcc,'||
11257: ' (SELECT DISTINCT bra.code_combination_id '||
11258: ' FROM PSB_BUDGET_REVISION_LINES brl,'||
11259: ' PSB_BUDGET_REVISION_ACCOUNTS bra '||
11260: ' WHERE brl.budget_revision_id = '||to_char(p_budget_revision_id)||

Line 11300: ' FROM gl_code_combinations glcc'||

11296: ' WHERE brl.budget_revision_id = :b_budget_revision_id'||
11297: ' AND bra.budget_revision_acct_line_id = brl.budget_revision_acct_line_id'||
11298: ' AND bra.code_combination_id = ba.code_combination_id)'||
11299: ' AND EXISTS (SELECT 1'||
11300: ' FROM gl_code_combinations glcc'||
11301: ' WHERE glcc.code_combination_id = ba.code_combination_id';
11302:
11303:
11304: OPEN l_seg_cur FOR l_seg_sql;