APPS.FV_YE_CLOSE dependencies on GL_CODE_COMBINATIONS

Line 1739: FROM Gl_Balances glb,Gl_Code_Combinations gcc

1735: 'any balances.');
1736: END IF;
1737:
1738: vl_select := 'SELECT COUNT(*)
1739: FROM Gl_Balances glb,Gl_Code_Combinations gcc
1740: WHERE glb.code_combination_id = gcc.code_combination_id
1741: AND gcc.'||vg_bal_segment||' = :fund_value'||
1742: ' AND gcc.'||vg_acct_segment|| ' = :from_acct'||
1743: ' AND gcc.summary_flag = '||''''||'N'||''''||

Line 1926: vl_ccid Gl_Code_Combinations.code_combination_id%TYPE;

1922: TYPE t_getbal IS REF CURSOR;
1923: vc_getbal t_getbal;
1924: vl_select VARCHAR2(2000);
1925:
1926: vl_ccid Gl_Code_Combinations.code_combination_id%TYPE;
1927:
1928: TYPE t_ccidtable IS TABLE OF Gl_Code_Combinations.code_combination_id%TYPE
1929: INDEX BY BINARY_INTEGER;
1930: vt_ccid t_ccidtable;

Line 1928: TYPE t_ccidtable IS TABLE OF Gl_Code_Combinations.code_combination_id%TYPE

1924: vl_select VARCHAR2(2000);
1925:
1926: vl_ccid Gl_Code_Combinations.code_combination_id%TYPE;
1927:
1928: TYPE t_ccidtable IS TABLE OF Gl_Code_Combinations.code_combination_id%TYPE
1929: INDEX BY BINARY_INTEGER;
1930: vt_ccid t_ccidtable;
1931: i BINARY_INTEGER ;
1932: vl_ccid_cnt NUMBER;

Line 2004: FROM Gl_Balances glb,Gl_Code_Combinations gcc

2000:
2001: vl_select := 'SELECT glb.code_combination_id,
2002: NVL(SUM(NVL(begin_balance_dr,0) + NVL(period_net_dr,0)) -
2003: SUM(NVL(begin_balance_cr,0) + NVL(period_net_cr,0)),0)
2004: FROM Gl_Balances glb,Gl_Code_Combinations gcc
2005: WHERE glb.code_combination_id = gcc.code_combination_id
2006: AND gcc.'||vg_bal_segment|| ' = :fund_value'||
2007: ' AND gcc.'||vg_acct_segment|| ' = :child_acct'||
2008: ' AND gcc.summary_flag = '||''''||'N'||''''||

Line 2278: vl_ccid Gl_Code_Combinations.code_combination_id%TYPE;

2274: vl_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
2275: vl_remaining_bal NUMBER;
2276: vl_drcr_flag VARCHAR2(1);
2277: vl_read_flag VARCHAR2(1);
2278: vl_ccid Gl_Code_Combinations.code_combination_id%TYPE;
2279: vl_processing_type Fv_Ye_Seq_Bal_Temp.processing_type%TYPE;
2280: vl_acct_combi VARCHAR2(2000);
2281: vl_delimeter VARCHAR2(1);
2282: v_cross_val_msg VARCHAR2(2000);

Line 2363: FROM gl_code_combinations gcc

2359: RAISE e_invalid;
2360: ELSE
2361: vl_ccid := NULL;
2362: l_ccid_select := 'SELECT code_combination_id
2363: FROM gl_code_combinations gcc
2364: WHERE gcc.chart_of_accounts_id = :coa_id ';
2365: FOR flex_rec IN flex_cursor (vg_coa_id) LOOP
2366: l_ccid_select := l_ccid_select ||
2367: ' and gcc.'||

Line 2942: FROM Po_Req_Distributions_All po, gl_code_combinations gcc,

2938:
2939: -- Build the select statement to get the distribution details
2940: vl_dist_select := 'SELECT po.distribution_id,
2941: po.requisition_line_id, ph.segment1
2942: FROM Po_Req_Distributions_All po, gl_code_combinations gcc,
2943: Po_Requisition_Lines_All pl, Po_Requisition_Headers_All ph
2944: WHERE po.gl_closed_date IS NULL
2945: AND gcc.code_combination_id = po.code_combination_id
2946: AND gcc.chart_of_accounts_id = :coa