APPS.FV_FACTS_TRANSACTIONS dependencies on GL_JE_LINES

Line 1188: vl_period_name gl_je_lines.period_name%TYPE;

1184: vl_legis_select VARCHAR2(5000) ;
1185: vl_legis_ref VARCHAR2(240) ;
1186: vl_legis_amount NUMBER := 0 ;
1187: vl_effective_date DATE;
1188: vl_period_name gl_je_lines.period_name%TYPE;
1189: vl_exception_cat NUMBER := 0;
1190: vl_sgl_acct_num_bak VARCHAR2(25);
1191: vl_tran_type VARCHAR2(25) ;
1192: vl_appor_cursor INTEGER ;

Line 1918: ' FROM gl_je_lines gjl,

1914: NVL(gjl.entered_dr, 0) - NVL(gjl.entered_cr, 0) amout,
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: WHERE gjl.code_combination_id = glcc.code_combination_id
1922: AND gjl.status = :je_status

Line 1954: ' FROM gl_je_lines gjl,

1950: NVL(xl.accounted_dr, 0) - NVL(xl.accounted_cr, 0) amount,
1951: gjl.effective_date , gjl.period_name, gjh.je_source '||
1952: va_pl_code_col || va_tr_main_acct_col || va_tr_dept_id_col ||
1953: va_advance_type_col ||
1954: ' FROM gl_je_lines gjl,
1955: gl_code_combinations glcc,
1956: gl_je_headers gjh,
1957: gl_import_references gli,
1958: xla_distribution_links xdl,