APPS.FV_FACTS_TRANSACTIONS dependencies on GL_JE_LINES

Line 1156: vl_period_name gl_je_lines.period_name%TYPE;

1152: vl_legis_select VARCHAR2(5000) ;
1153: vl_legis_ref VARCHAR2(240) ;
1154: vl_legis_amount NUMBER := 0 ;
1155: vl_effective_date DATE;
1156: vl_period_name gl_je_lines.period_name%TYPE;
1157: vl_exception_cat NUMBER := 0;
1158: vl_sgl_acct_num_bak VARCHAR2(25);
1159: vl_tran_type VARCHAR2(25) ;
1160: vl_appor_cursor INTEGER ;

Line 1882: ' FROM gl_je_lines gjl,

1878: NVL(gjl.entered_dr, 0) - NVL(gjl.entered_cr, 0) amout,
1879: gjl.effective_date , gjl.period_name, gjh.je_source '||
1880: va_pl_code_col || va_tr_main_acct_col || va_tr_dept_id_col ||
1881: va_advance_type_col ||
1882: ' FROM gl_je_lines gjl,
1883: gl_code_combinations glcc,
1884: gl_je_headers gjh
1885: WHERE gjl.code_combination_id = glcc.code_combination_id
1886: AND gjl.status = :je_status

Line 1918: ' FROM gl_je_lines gjl,

1914: NVL(xl.accounted_dr, 0) - NVL(xl.accounted_cr, 0) amount,
1915: gjl.effective_date , gjl.period_name, gjh.je_source '||
1916: va_pl_code_col || va_tr_main_acct_col || va_tr_dept_id_col ||
1917: va_advance_type_col ||
1918: ' FROM gl_je_lines gjl,
1919: gl_code_combinations glcc,
1920: gl_je_headers gjh,
1921: gl_import_references gli,
1922: xla_distribution_links xdl,