APPS.HR_GBNIDIR dependencies on PAY_INPUT_VALUES_F

Line 811: from pay_input_values_f

807: and effective_end_date;
808: --
809: select input_value_id
810: into g_cat_input_id
811: from pay_input_values_f
812: where name = 'Category'
813: and element_type_id = g_ni_element_type_id
814: and sysdate between effective_start_date
815: and effective_end_date;

Line 819: from pay_input_values_f

815: and effective_end_date;
816: --
817: select input_value_id
818: into g_pen_input_id
819: from pay_input_values_f
820: where name = 'Pension'
821: and element_type_id = g_ni_element_type_id
822: and sysdate between effective_start_date
823: and effective_end_date;

Line 1325: from pay_input_values_f

1321: effective_start_date and effective_end_date;
1322: --
1323: select input_value_id
1324: into l_period_type_id
1325: from pay_input_values_f
1326: where name = 'Priority Period Type'
1327: and element_type_id = l_element_type_id
1328: and l_effective_date between
1329: effective_start_date and effective_end_date;

Line 1724: from pay_input_values_f_tl IV_TL,

1720: AND type_tl.element_name = p_element_name;
1721: --
1722: select iv.input_value_id
1723: into l_input_id
1724: from pay_input_values_f_tl IV_TL,
1725: pay_input_values_f IV
1726: where iv_tl.input_value_id = iv.input_value_id
1727: and userenv('LANG') = iv_tl.language
1728: and iv_tl.name = p_input_name

Line 1725: pay_input_values_f IV

1721: --
1722: select iv.input_value_id
1723: into l_input_id
1724: from pay_input_values_f_tl IV_TL,
1725: pay_input_values_f IV
1726: where iv_tl.input_value_id = iv.input_value_id
1727: and userenv('LANG') = iv_tl.language
1728: and iv_tl.name = p_input_name
1729: and iv.element_type_id = l_element_type_id

Line 1785: from pay_input_values_f

1781: effective_start_date and effective_end_date;
1782: --
1783: select input_value_id
1784: into l_cat_input_id
1785: from pay_input_values_f
1786: where name = 'Category'
1787: and element_type_id = l_element_type_id
1788: and p_effective_date between
1789: effective_start_date and effective_end_date;

Line 1793: from pay_input_values_f

1789: effective_start_date and effective_end_date;
1790: --
1791: select input_value_id
1792: into l_pen_input_id
1793: from pay_input_values_f
1794: where name = 'Pension'
1795: and element_type_id = l_element_type_id
1796: and p_effective_date between
1797: effective_start_date and effective_end_date;

Line 1888: from pay_input_values_f

1884: and effective_end_date;
1885: --
1886: select input_value_id
1887: into g_cat_input_id
1888: from pay_input_values_f
1889: where name = 'Category'
1890: and element_type_id = g_ni_element_type_id
1891: and sysdate between effective_start_date
1892: and effective_end_date;

Line 1896: from pay_input_values_f

1892: and effective_end_date;
1893: --
1894: select input_value_id
1895: into g_pen_input_id
1896: from pay_input_values_f
1897: where name = 'Pension'
1898: and element_type_id = g_ni_element_type_id
1899: and sysdate between effective_start_date
1900: and effective_end_date;

Line 2132: from pay_input_values_f piv,

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