APPS.FV_FACTS_TBAL_TRX dependencies on GL_JE_LINES

Line 753: vl_period_name gl_je_lines.period_name%TYPE;

749: vl_amount Number ;
750:
751: vl_row_count Number := 0 ;
752:
753: vl_period_name gl_je_lines.period_name%TYPE;
754: vl_adj_flag VARCHAR2(1);
755: vl_adj_num NUMBER;
756: vl_attributes_found varchar2(1) ;
757: vl_period_activity NUMBER;

Line 1344: ' From gl_je_lines gjl,

1340: Nvl(gjl.entered_dr, 0) period_dr , Nvl(gjl.entered_cr, 0) period_cr,
1341: gjh.je_source ,gjh.je_header_id , gjl.je_line_num , gjh.je_batch_id,je_from_sla_flag '||
1342: va_pl_code_col || va_tr_main_acct_col || va_tr_dept_id_col ||
1343: va_advance_type_col ||
1344: ' From gl_je_lines gjl,
1345: gl_code_combinations glcc,
1346: gl_je_headers gjh
1347: Where gjl.code_combination_id = glcc.code_combination_id
1348: AND glcc.code_combination_id = :ccid ';