APPS.HR_GBNIDIR dependencies on PAY_ELEMENT_TYPES_F

Line 804: from pay_element_types_f

800: where balance_name = 'NIable Pay';
801: --
802: select element_type_id
803: into g_ni_element_type_id
804: from pay_element_types_f
805: where element_name = 'NI'
806: and sysdate between effective_start_date
807: and effective_end_date;
808: --

Line 1318: from pay_element_types_f

1314: --
1315: -- Get the id's of the NI startup data
1316: select element_type_id
1317: into l_element_type_id
1318: from pay_element_types_f
1319: where element_name = 'NI'
1320: and l_effective_date between
1321: effective_start_date and effective_end_date;
1322: --

Line 1712: FROM pay_element_types_f_tl type_tl

1708: -- Get the id's of the setup data
1709: --
1710: SELECT type_tl.element_type_id
1711: INTO l_element_type_id
1712: FROM pay_element_types_f_tl type_tl
1713: WHERE EXISTS
1714: (SELECT 1
1715: FROM pay_element_types_f type
1716: WHERE type.element_type_id = type_tl.element_type_id

Line 1715: FROM pay_element_types_f type

1711: INTO l_element_type_id
1712: FROM pay_element_types_f_tl type_tl
1713: WHERE EXISTS
1714: (SELECT 1
1715: FROM pay_element_types_f type
1716: WHERE type.element_type_id = type_tl.element_type_id
1717: AND p_effective_date BETWEEN
1718: type.effective_start_date AND type.effective_end_date)
1719: AND type_tl.language = USERENV ('LANG')

Line 1778: from pay_element_types_f

1774: -- Get the id's of the setup data
1775: if g_ni_element_type_id is null then
1776: select element_type_id
1777: into l_element_type_id
1778: from pay_element_types_f
1779: where element_name = 'NI'
1780: and p_effective_date between
1781: effective_start_date and effective_end_date;
1782: --

Line 1881: from pay_element_types_f

1877: where balance_name = 'NIable Pay';
1878: --
1879: select element_type_id
1880: into g_ni_element_type_id
1881: from pay_element_types_f
1882: where element_name = 'NI'
1883: and sysdate between effective_start_date
1884: and effective_end_date;
1885: --

Line 2133: pay_element_types_f pet

2129: cursor ni_element_type (c_effective_date date) is
2130: select pet.element_type_id,
2131: piv.input_value_id
2132: from pay_input_values_f piv,
2133: pay_element_types_f pet
2134: where pet.element_name = 'NI'
2135: and c_effective_date between
2136: pet.effective_start_date and pet.effective_end_date
2137: and piv.element_type_id = pet.element_type_id