APPS.PAY_FR_BAL_UPLOAD dependencies on PAY_ELEMENT_TYPES_F

Line 274: l_element_type_id pay_element_types_f.element_type_id%TYPE;

270: l_business_group_name per_business_groups_perf.name%TYPE;
271: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
272: l_BG_currency_code per_business_groups_perf.currency_code%TYPE;
273: l_prev_currency_code pay_balance_types.currency_code%TYPE;
274: l_element_type_id pay_element_types_f.element_type_id%TYPE;
275: l_element_name pay_element_types_f.element_name%TYPE;
276: l_element_counter number;
277: l_element_link_id number;
278: l_iv_counter number;

Line 275: l_element_name pay_element_types_f.element_name%TYPE;

271: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
272: l_BG_currency_code per_business_groups_perf.currency_code%TYPE;
273: l_prev_currency_code pay_balance_types.currency_code%TYPE;
274: l_element_type_id pay_element_types_f.element_type_id%TYPE;
275: l_element_name pay_element_types_f.element_name%TYPE;
276: l_element_counter number;
277: l_element_link_id number;
278: l_iv_counter number;
279: --

Line 321: pay_element_types_f pet,

317: and nvl(pbt.legislation_code, l_legislation_code) = l_legislation_code
318: and not exists(
319: select 1
320: from pay_element_classifications pec,
321: pay_element_types_f pet,
322: pay_input_values_f piv,
323: pay_balance_feeds_f pbf
324: where pbf.balance_type_id = pbt.balance_type_id
325: and pbf.effective_start_date = g_sot

Line 433: from pay_element_types_f

429: select
430: nvl(max(to_number(translate(upper(substr(element_name,
431: instr(element_name,'_',-1)+1))
432: ,'0 _'||g_alphabet,'0'))),0)+1
433: from pay_element_types_f
434: where element_name like p_prefix;
435: begin
436: open csr_et(g_element_name_prefix || p_batch_id || '%');
437: fetch csr_et into l_element_counter;

Line 462: update pay_element_types_f

458: p_process_in_run_flag => 'Y',
459: p_business_group_name => l_business_group_name,
460: p_post_termination_rule => 'Final Close');
461: --
462: update pay_element_types_f
463: set element_information1 = 'B'
464: where element_type_id = p_element_type_id;
465: --
466: p_element_link_id := pay_db_pay_setup.create_element_link(