APPS.HR_GBNIDIR dependencies on PAY_INPUT_VALUES_F

Line 887: from pay_input_values_f

883: and effective_end_date;
884: --
885: select input_value_id
886: into g_cat_input_id
887: from pay_input_values_f
888: where name = 'Category'
889: and element_type_id = g_ni_element_type_id
890: and sysdate between effective_start_date
891: and effective_end_date;

Line 895: from pay_input_values_f

891: and effective_end_date;
892: --
893: select input_value_id
894: into g_pen_input_id
895: from pay_input_values_f
896: where name = 'Pension'
897: and element_type_id = g_ni_element_type_id
898: and sysdate between effective_start_date
899: and effective_end_date;

Line 1425: from pay_input_values_f

1421: effective_start_date and effective_end_date;
1422: --
1423: select input_value_id
1424: into l_period_type_id
1425: from pay_input_values_f
1426: where name = 'Priority Period Type'
1427: and element_type_id = l_element_type_id
1428: and l_effective_date between
1429: effective_start_date and effective_end_date;

Line 1840: from pay_input_values_f_tl IV_TL,

1836: AND type_tl.element_name = p_element_name;
1837: --
1838: select iv.input_value_id
1839: into l_input_id
1840: from pay_input_values_f_tl IV_TL,
1841: pay_input_values_f IV
1842: where iv_tl.input_value_id = iv.input_value_id
1843: and userenv('LANG') = iv_tl.language
1844: and iv_tl.name = p_input_name

Line 1841: pay_input_values_f IV

1837: --
1838: select iv.input_value_id
1839: into l_input_id
1840: from pay_input_values_f_tl IV_TL,
1841: pay_input_values_f IV
1842: where iv_tl.input_value_id = iv.input_value_id
1843: and userenv('LANG') = iv_tl.language
1844: and iv_tl.name = p_input_name
1845: and iv.element_type_id = l_element_type_id

Line 1901: from pay_input_values_f

1897: effective_start_date and effective_end_date;
1898: --
1899: select input_value_id
1900: into l_cat_input_id
1901: from pay_input_values_f
1902: where name = 'Category'
1903: and element_type_id = l_element_type_id
1904: and p_effective_date between
1905: effective_start_date and effective_end_date;

Line 1909: from pay_input_values_f

1905: effective_start_date and effective_end_date;
1906: --
1907: select input_value_id
1908: into l_pen_input_id
1909: from pay_input_values_f
1910: where name = 'Pension'
1911: and element_type_id = l_element_type_id
1912: and p_effective_date between
1913: effective_start_date and effective_end_date;

Line 2004: from pay_input_values_f

2000: and effective_end_date;
2001: --
2002: select input_value_id
2003: into g_cat_input_id
2004: from pay_input_values_f
2005: where name = 'Category'
2006: and element_type_id = g_ni_element_type_id
2007: and sysdate between effective_start_date
2008: and effective_end_date;

Line 2012: from pay_input_values_f

2008: and effective_end_date;
2009: --
2010: select input_value_id
2011: into g_pen_input_id
2012: from pay_input_values_f
2013: where name = 'Pension'
2014: and element_type_id = g_ni_element_type_id
2015: and sysdate between effective_start_date
2016: and effective_end_date;

Line 2248: from pay_input_values_f piv,

2244: --
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