APPS.FV_FACTS_TRX_REGISTER dependencies on GL_JE_HEADERS

Line 36: g_from_gl_posted_date gl_je_headers.posted_date%TYPE;

32: g_attributes_found VARCHAR2(1);
33: g_req_date_seg VARCHAR2(15) := NULL;
34: g_pur_order_date_seg VARCHAR2(15) := NULL;
35: g_rec_trxn_date_seg VARCHAR2(15) := NULL;
36: g_from_gl_posted_date gl_je_headers.posted_date%TYPE;
37: g_to_gl_posted_date gl_je_headers.posted_date%TYPE;
38:
39:
40: g_funds_count NUMBER;

Line 37: g_to_gl_posted_date gl_je_headers.posted_date%TYPE;

33: g_req_date_seg VARCHAR2(15) := NULL;
34: g_pur_order_date_seg VARCHAR2(15) := NULL;
35: g_rec_trxn_date_seg VARCHAR2(15) := NULL;
36: g_from_gl_posted_date gl_je_headers.posted_date%TYPE;
37: g_to_gl_posted_date gl_je_headers.posted_date%TYPE;
38:
39:
40: g_funds_count NUMBER;
41:

Line 856: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;

852: l_cohort_num_year NUMBER;
853: l_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%TYPE;
854: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%TYPE;
855: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;
856: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;
857: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;
858: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;
859: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;
860: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;

Line 1123: gl_je_headers gjh,

1119: l_reimb_act_select ||
1120: l_pl_code_col || l_advance_type_col ||
1121: l_tr_dept_id_col || l_tr_main_acct_col ||
1122: ' FROM gl_je_batches gjb,
1123: gl_je_headers gjh,
1124: gl_je_lines gjl,
1125: gl_code_combinations glc,
1126: fv_treasury_symbols fts,
1127: fv_fund_parameters ffp

Line 1199: gl_je_headers gjh,

1195: l_reimb_act_select ||
1196: l_pl_code_col || l_advance_type_col ||
1197: l_tr_dept_id_col || l_tr_main_acct_col ||
1198: ' FROM gl_je_batches gjb,
1199: gl_je_headers gjh,
1200: gl_je_lines gjl,
1201: gl_code_combinations glc,
1202: fv_treasury_symbols fts,
1203: fv_fund_parameters ffp,

Line 3343: FROM gl_je_headers

3339: WHERE to_char(po_distribution_id) = p_reference3;
3340: */
3341: CURSOR Manual IS
3342: SELECT default_effective_date
3343: FROM gl_je_headers
3344: WHERE je_header_id = p_je_header_id;
3345: CURSOR Receivables_Adjustment IS
3346: SELECT apply_date, creation_date, created_by
3347: FROM ar_adjustments_all