APPS.FV_FACTS_TRX_REGISTER dependencies on GL_JE_HEADERS

Line 35: g_from_gl_posted_date gl_je_headers.posted_date%TYPE;

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

Line 36: g_to_gl_posted_date gl_je_headers.posted_date%TYPE;

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

Line 824: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;

820: l_cohort_num_year NUMBER;
821: l_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%TYPE;
822: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%TYPE;
823: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;
824: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;
825: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;
826: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;
827: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;
828: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;

Line 1080: gl_je_headers gjh,

1076: l_cohort_select ||
1077: l_pl_code_col || l_advance_type_col ||
1078: l_tr_dept_id_col || l_tr_main_acct_col ||
1079: ' FROM gl_je_batches gjb,
1080: gl_je_headers gjh,
1081: gl_je_lines gjl,
1082: gl_code_combinations glc,
1083: fv_treasury_symbols fts,
1084: fv_fund_parameters ffp

Line 1155: gl_je_headers gjh,

1151: l_cohort_select ||
1152: l_pl_code_col || l_advance_type_col ||
1153: l_tr_dept_id_col || l_tr_main_acct_col ||
1154: ' FROM gl_je_batches gjb,
1155: gl_je_headers gjh,
1156: gl_je_lines gjl,
1157: gl_code_combinations glc,
1158: fv_treasury_symbols fts,
1159: fv_fund_parameters ffp,

Line 3129: FROM gl_je_headers

3125: WHERE to_char(po_distribution_id) = p_reference3;
3126: */
3127: CURSOR Manual IS
3128: SELECT default_effective_date
3129: FROM gl_je_headers
3130: WHERE je_header_id = p_je_header_id;
3131: CURSOR Receivables_Adjustment IS
3132: SELECT apply_date, creation_date, created_by
3133: FROM ar_adjustments_all