APPS.FV_FACTS_TBAL_TRX dependencies on GL_JE_LINES

Line 677: vl_period_name gl_je_lines.period_name%TYPE;

673: vl_req_id Number ;
674: vl_row_count Number := 0 ;
675: vl_exists Varchar2(1) ;
676: vl_type Varchar2(3) ;
677: vl_period_name gl_je_lines.period_name%TYPE;
678: vl_adj_flag VARCHAR2(1);
679: vl_adj_num NUMBER;
680: vl_attributes_found varchar2(1) ;
681: vl_period_activity NUMBER;

Line 1221: ' From gl_je_lines gjl,

1217: Nvl(gjl.entered_dr, 0) period_dr , Nvl(gjl.entered_cr, 0) period_cr,
1218: gjh.je_source ,gjh.je_header_id , gjl.je_line_num , gjh.je_batch_id,je_from_sla_flag '||
1219: va_pl_code_col || va_tr_main_acct_col || va_tr_dept_id_col ||
1220: va_advance_type_col ||
1221: ' From gl_je_lines gjl,
1222: gl_code_combinations glcc,
1223: gl_je_headers gjh
1224: Where gjl.code_combination_id = glcc.code_combination_id
1225: AND glcc.code_combination_id = :ccid ';