APPS.PAY_DB_PAY_SETUP dependencies on PAY_ELEMENT_TYPES_F

Line 562: from pay_element_types_f

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

Line 571: from pay_element_types_f

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

Line 593: from pay_element_types_f et

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

Line 1216: from pay_element_types_f et

1212: v_el_multiply_value_flag,
1213: v_el_qual_age,
1214: v_el_qual_lngth_of_service,
1215: v_el_qual_units
1216: from pay_element_types_f et
1217: where upper(et.element_name) = upper(p_element_name)
1218: and (et.business_group_id + 0 = v_business_group_id
1219: or (et.business_group_id is null
1220: and et.legislation_code = v_legislation_code)

Line 1542: , pay_element_types_f pet

1538: is
1539: select piv.input_value_id
1540: , pet.element_type_id
1541: from pay_input_values_f piv
1542: , pay_element_types_f pet
1543: , pay_input_values_f_tl pivtl
1544: , pay_element_types_f_tl pettl
1545: where piv.input_value_id = pivtl.input_value_id
1546: and pivtl.language = userenv('LANG')

Line 1544: , pay_element_types_f_tl pettl

1540: , pet.element_type_id
1541: from pay_input_values_f piv
1542: , pay_element_types_f pet
1543: , pay_input_values_f_tl pivtl
1544: , pay_element_types_f_tl pettl
1545: where piv.input_value_id = pivtl.input_value_id
1546: and pivtl.language = userenv('LANG')
1547: and pivtl.name = p_prim_iv
1548: and pet.element_type_id = pettl.element_type_id

Line 1581: l_prim_ele pay_element_types_f.element_type_id%type;

1577: l_ctl_leg varchar2(30);
1578: l_bt_id pay_balance_types.balance_type_id%type;
1579: l_bbt_id pay_balance_types.base_balance_type_id%type;
1580: l_prim_iv pay_balance_types.input_value_id%type;
1581: l_prim_ele pay_element_types_f.element_type_id%type;
1582: l_mode varchar2(30);
1583: --
1584: begin
1585: g_debug := hr_utility.debug_enabled;