APPS.PAY_DB_PAY_SETUP dependencies on PAY_ELEMENT_TYPES_F

Line 564: from pay_element_types_f

560: -- Store the dates over which time the element type exists
561: if v_business_group_id is not NULL then
562: select element_name
563: into v_ele_name
564: from pay_element_types_f
565: where element_name = p_element_name
566: and (business_group_id = v_business_group_id OR
567: (business_group_id is NULL and legislation_code = p_legislation_code))
568: and v_session_date between effective_start_date and

Line 573: from pay_element_types_f

569: effective_end_date; /* new bug 1576000 */
570: else
571: select element_name
572: into v_ele_name
573: from pay_element_types_f
574: where element_name = p_element_name
575: and legislation_code = p_legislation_code
576: and v_session_date between effective_start_date and
577: effective_end_date; /* new bug 1576000 */

Line 595: from pay_element_types_f et

591: into v_element_start_date,
592: v_element_end_date,
593: v_legislation_subgroup,
594: v_element_type_id
595: from pay_element_types_f et
596: where upper(et.element_name) = upper(p_element_name)
597: and (et.business_group_id + 0 = v_business_group_id
598: or (et.business_group_id is null
599: and et.legislation_code = v_legislation_code)

Line 1239: from pay_element_types_f et

1235: v_el_multiply_value_flag,
1236: v_el_qual_age,
1237: v_el_qual_lngth_of_service,
1238: v_el_qual_units
1239: from pay_element_types_f et
1240: where upper(et.element_name) = upper(p_element_name)
1241: and (et.business_group_id + 0 = v_business_group_id
1242: or (et.business_group_id is null
1243: and et.legislation_code = v_legislation_code)

Line 1565: , pay_element_types_f pet

1561: is
1562: select piv.input_value_id
1563: , pet.element_type_id
1564: from pay_input_values_f piv
1565: , pay_element_types_f pet
1566: , pay_input_values_f_tl pivtl
1567: , pay_element_types_f_tl pettl
1568: where piv.input_value_id = pivtl.input_value_id
1569: and pivtl.language = userenv('LANG')

Line 1567: , pay_element_types_f_tl pettl

1563: , pet.element_type_id
1564: from pay_input_values_f piv
1565: , pay_element_types_f pet
1566: , pay_input_values_f_tl pivtl
1567: , pay_element_types_f_tl pettl
1568: where piv.input_value_id = pivtl.input_value_id
1569: and pivtl.language = userenv('LANG')
1570: and pivtl.name = p_prim_iv
1571: and pet.element_type_id = pettl.element_type_id

Line 1604: l_prim_ele pay_element_types_f.element_type_id%type;

1600: l_ctl_leg varchar2(30);
1601: l_bt_id pay_balance_types.balance_type_id%type;
1602: l_bbt_id pay_balance_types.base_balance_type_id%type;
1603: l_prim_iv pay_balance_types.input_value_id%type;
1604: l_prim_ele pay_element_types_f.element_type_id%type;
1605: l_mode varchar2(30);
1606: --
1607: begin
1608: g_debug := hr_utility.debug_enabled;