DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on GL_JE_HEADERS

Line 1172: vl_je_source gl_je_headers.je_source%TYPE;

1168: vl_req_id NUMBER ;
1169: vl_disbursements_flag VARCHAR2(1);
1170: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%TYPE;
1171:
1172: vl_je_source gl_je_headers.je_source%TYPE;
1173: vl_pl_code VARCHAR2(150);
1174: vl_tr_main_acct VARCHAR2(150);
1175: vl_tr_dept_id VARCHAR2(150);
1176: vl_advance_type VARCHAR2(150);

Line 1884: gl_je_headers gjh

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
1887: AND gjl.ledger_id = :set_of_books_id
1888: AND glcc.'||v_acc_seg_name|| ' = :acct_num

Line 1920: gl_je_headers gjh,

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,
1923: xla_ae_lines xl
1924: WHERE gjl.code_combination_id = glcc.code_combination_id