DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on GL_JE_HEADERS

Line 1204: vl_je_source gl_je_headers.je_source%TYPE;

1200: vl_req_id NUMBER ;
1201: vl_disbursements_flag VARCHAR2(1);
1202: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%TYPE;
1203:
1204: vl_je_source gl_je_headers.je_source%TYPE;
1205: vl_pl_code VARCHAR2(150);
1206: vl_tr_main_acct VARCHAR2(150);
1207: vl_tr_dept_id VARCHAR2(150);
1208: vl_advance_type VARCHAR2(150);

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: WHERE gjl.code_combination_id = glcc.code_combination_id
1922: AND gjl.status = :je_status
1923: AND gjl.ledger_id = :set_of_books_id
1924: AND glcc.'||v_acc_seg_name|| ' = :acct_num

Line 1956: gl_je_headers gjh,

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