APPS.FV_GTAS_TRX_REGISTER dependencies on GL_JE_HEADERS

Line 51: g_from_gl_posted_date gl_je_headers.posted_date%TYPE;

47: g_attributes_found VARCHAR2(1);
48: g_req_date_seg VARCHAR2(15) := NULL;
49: g_pur_order_date_seg VARCHAR2(15) := NULL;
50: g_rec_trxn_date_seg VARCHAR2(15) := NULL;
51: g_from_gl_posted_date gl_je_headers.posted_date%TYPE;
52: g_to_gl_posted_date gl_je_headers.posted_date%TYPE;
53:
54: Vl_Catb_Rc_Map_Status Varchar2(10);
55: Vl_Prn_Rc_Map_Status Varchar2(10);

Line 52: g_to_gl_posted_date gl_je_headers.posted_date%TYPE;

48: g_req_date_seg VARCHAR2(15) := NULL;
49: g_pur_order_date_seg VARCHAR2(15) := NULL;
50: g_rec_trxn_date_seg VARCHAR2(15) := NULL;
51: g_from_gl_posted_date gl_je_headers.posted_date%TYPE;
52: g_to_gl_posted_date gl_je_headers.posted_date%TYPE;
53:
54: Vl_Catb_Rc_Map_Status Varchar2(10);
55: Vl_Prn_Rc_Map_Status Varchar2(10);
56: Vl_Pci_Rc_Map_Status Varchar2(10);

Line 1539: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;

1535:
1536: l_cohort_select VARCHAR2(100) ;
1537: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%TYPE;
1538: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;
1539: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;
1540: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;
1541: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;
1542: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;
1543: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;

Line 1779: gl_je_headers gjh,

1775: l_reimb_act_select ||
1776: l_pl_code_col || l_advance_type_col ||
1777: l_tr_dept_id_col || l_tr_main_acct_col ||
1778: ' FROM gl_je_lines gjl,
1779: gl_je_headers gjh,
1780: gl_je_batches gjb,
1781: gl_code_combinations gcc,
1782: fv_fund_parameters ffp,
1783: fv_treasury_symbols fts

Line 1859: gl_je_headers gjh,

1855: l_reimb_act_select ||
1856: l_pl_code_col || l_advance_type_col ||
1857: l_tr_dept_id_col || l_tr_main_acct_col ||
1858: ' FROM gl_je_lines gjl,
1859: gl_je_headers gjh,
1860: gl_je_batches gjb,
1861: gl_code_combinations gcc,
1862: fv_fund_parameters ffp,
1863: fv_treasury_symbols fts,

Line 3482: FROM gl_je_headers

3478: AND h.doc_id = d.doc_id;
3479:
3480: CURSOR Manual IS
3481: SELECT default_effective_date
3482: FROM gl_je_headers
3483: WHERE je_header_id = p_je_header_id;
3484: CURSOR Receivables_Adjustment IS
3485: SELECT apply_date, creation_date, created_by
3486: FROM ar_adjustments_all