APPS.JE_IT_INVOICES_ABOVE_THRESHOLD dependencies on JE_IT_SETUP_HEADER_ALL

Line 55: FROM je_it_setup_header_all

51: l_schema_name VARCHAR2(10);
52:
53: CURSOR cur_frozen(p_vat_reporting_entity_id NUMBER,p_year NUMBER) IS
54: SELECT freeze_indicator_flag
55: FROM je_it_setup_header_all
56: WHERE year_of_declaration = p_year
57: AND vat_reporting_entity_id = p_vat_reporting_entity_id;
58:
59: CURSOR cur_report_mode(p_vat_reporting_entity_id NUMBER,p_year NUMBER,p_type_of_upload NUMBER) IS

Line 280: FROM je_it_setup_header_all

276:
277: debug_message('before fetching default payment mode');
278: SELECT default_payment_mode
279: INTO g_default_payment_mode
280: FROM je_it_setup_header_all
281: WHERE year_of_declaration = p_year
282: AND vat_reporting_entity_id = p_vat_reporting_entity_id
283: AND ROWNUM = 1; -- form has validation. only one record exists for declaration year.
284: debug_message('g_default_payment_mode:'||g_default_payment_mode);