APPS.FV_SLA_PROCESSING_PKG dependencies on GL_CODE_COMBINATIONS

Line 630: l_ccid Gl_Code_Combinations.code_combination_id%TYPE;

626:
627: l_anticipated_acct VARCHAR2(30);
628: l_template_id NUMBER;
629: l_currency_code VARCHAR2(30);
630: l_ccid Gl_Code_Combinations.code_combination_id%TYPE;
631: l_fund_value Fv_Fund_Parameters.fund_value%TYPE;
632: l_amount NUMBER;
633: l_tot_amount NUMBER := 0;
634:

Line 693: ' FROM Gl_Code_Combinations ' ||

689: l_fund_cur_id := DBMS_SQL.OPEN_CURSOR;
690:
691: --Build the Select statement for getting the fund values and ccids
692: l_fund_select := 'SELECT code_combination_id ' ||
693: ' FROM Gl_Code_Combinations ' ||
694: ' WHERE chart_of_accounts_id = :p_coaid AND '||
695: 'segment'||p_balancing_segment || ' = :p_fund_value AND ' ||
696: 'template_id = :p_template_id AND '||
697: 'Summary_flag = ''Y''' ;

Line 721: -- Fetch the ccid's from Gl_Code_Combinations

717:
718: l_fund_ret := DBMS_SQL.EXECUTE(l_fund_cur_id);
719:
720: LOOP
721: -- Fetch the ccid's from Gl_Code_Combinations
722: -------------------------------------------------------------------------
723: trace(C_STATE_LEVEL, l_procedure_name, 'FETCH_ROWS');
724: -------------------------------------------------------------------------
725: IF DBMS_SQL.FETCH_ROWS(l_fund_cur_id) = 0 THEN

Line 749: FROM gl_code_combinations

745: AND period_name = p_period_name;
746:
747: SELECT code_combination_id
748: INTO l_ccid
749: FROM gl_code_combinations
750: WHERE chart_of_accounts_id = p_coaid
751: AND template_id = l_template_id
752: AND summary_flag = 'Y';*/
753:

Line 1398: ' FROM gl_code_combinations WHERE code_combination_id = :x_ccid' ||

1394:
1395: -- DEBUG('Fiscal year segment '|| l_bfy_segment.application_column_name);
1396:
1397: EXECUTE IMMEDIATE 'SELECT ' || l_bfy_segment.application_column_name ||
1398: ' FROM gl_code_combinations WHERE code_combination_id = :x_ccid' ||
1399: ' AND chart_of_accounts_id = :x_coaid '
1400: INTO l_bfy_segment_value USING p_ccid, p_coa_id;
1401: -- ================================== FND_LOG ==================================
1402: l_debug_info := 'BFY Segment value from gl_code_combinations table: '|| l_bfy_segment_value;

Line 1402: l_debug_info := 'BFY Segment value from gl_code_combinations table: '|| l_bfy_segment_value;

1398: ' FROM gl_code_combinations WHERE code_combination_id = :x_ccid' ||
1399: ' AND chart_of_accounts_id = :x_coaid '
1400: INTO l_bfy_segment_value USING p_ccid, p_coa_id;
1401: -- ================================== FND_LOG ==================================
1402: l_debug_info := 'BFY Segment value from gl_code_combinations table: '|| l_bfy_segment_value;
1403: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info);
1404: -- ================================== FND_LOG ==================================
1405: -- DEBUG('Fiscal year segment value '||l_bfy_segment_value);
1406: