APPS.HR_GBNIDIR dependencies on PAY_ELEMENT_TYPES_F

Line 880: from pay_element_types_f

876: where balance_name = 'NIable Pay';
877: --
878: select element_type_id
879: into g_ni_element_type_id
880: from pay_element_types_f
881: where element_name = 'NI'
882: and sysdate between effective_start_date
883: and effective_end_date;
884: --

Line 1418: from pay_element_types_f

1414: --
1415: -- Get the id's of the NI startup data
1416: select element_type_id
1417: into l_element_type_id
1418: from pay_element_types_f
1419: where element_name = 'NI'
1420: and l_effective_date between
1421: effective_start_date and effective_end_date;
1422: --

Line 1828: FROM pay_element_types_f_tl type_tl

1824: -- Get the id's of the setup data
1825: --
1826: SELECT type_tl.element_type_id
1827: INTO l_element_type_id
1828: FROM pay_element_types_f_tl type_tl
1829: WHERE EXISTS
1830: (SELECT 1
1831: FROM pay_element_types_f type
1832: WHERE type.element_type_id = type_tl.element_type_id

Line 1831: FROM pay_element_types_f type

1827: INTO l_element_type_id
1828: FROM pay_element_types_f_tl type_tl
1829: WHERE EXISTS
1830: (SELECT 1
1831: FROM pay_element_types_f type
1832: WHERE type.element_type_id = type_tl.element_type_id
1833: AND p_effective_date BETWEEN
1834: type.effective_start_date AND type.effective_end_date)
1835: AND type_tl.language = USERENV ('LANG')

Line 1894: from pay_element_types_f

1890: -- Get the id's of the setup data
1891: if g_ni_element_type_id is null then
1892: select element_type_id
1893: into l_element_type_id
1894: from pay_element_types_f
1895: where element_name = 'NI'
1896: and p_effective_date between
1897: effective_start_date and effective_end_date;
1898: --

Line 1997: from pay_element_types_f

1993: where balance_name = 'NIable Pay';
1994: --
1995: select element_type_id
1996: into g_ni_element_type_id
1997: from pay_element_types_f
1998: where element_name = 'NI'
1999: and sysdate between effective_start_date
2000: and effective_end_date;
2001: --

Line 2249: pay_element_types_f pet

2245: cursor ni_element_type (c_effective_date date) is
2246: select pet.element_type_id,
2247: piv.input_value_id
2248: from pay_input_values_f piv,
2249: pay_element_types_f pet
2250: where pet.element_name = 'NI'
2251: and c_effective_date between
2252: pet.effective_start_date and pet.effective_end_date
2253: and piv.element_type_id = pet.element_type_id