APPS.PAY_NL_SI_PKG dependencies on PAY_INPUT_VALUES_F

Line 1578: l_input_value_id pay_input_values_f.input_value_id%TYPE;

1574: l_per_end_date DATE;
1575:
1576: --6887820
1577: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1578: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1579: l_prorate_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1580:
1581: --6887820
1582: CURSOR ele_typ_id

Line 1593: select input_value_id from pay_input_values_f

1589: and legislation_code = 'NL';
1590:
1591: CURSOR inp_val_id(p_element_type_id NUMBER)
1592: IS
1593: select input_value_id from pay_input_values_f
1594: where element_type_id = p_element_type_id
1595: and p_proration_start_date between effective_start_date and effective_end_date
1596: and legislation_code = 'NL';
1597:

Line 1608: pay_input_values_f INPUTV

1604: FROM
1605: pay_element_entry_values_f EEV,
1606: pay_element_entries_f EE,
1607: pay_link_input_values_f LIV,
1608: pay_input_values_f INPUTV
1609: WHERE INPUTV.input_value_id = l_input_value_id
1610: AND p_proration_start_date BETWEEN INPUTV.effective_start_date AND INPUTV.effective_end_date
1611: AND INPUTV.element_type_id = l_element_type_id
1612: AND LIV.input_value_id = INPUTV.input_value_id

Line 1879: l_input_value_id pay_input_values_f.input_value_id%TYPE;

1875: RETURN varchar2 IS
1876: l_override_si_days varchar2(35);
1877:
1878: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1879: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1880: l_prorate_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1881:
1882: --6887820
1883: CURSOR ele_typ_id

Line 1894: select input_value_id from pay_input_values_f

1890: and legislation_code = 'NL';
1891:
1892: CURSOR inp_val_id(p_element_type_id NUMBER)
1893: IS
1894: select input_value_id from pay_input_values_f
1895: where element_type_id = p_element_type_id
1896: and p_date_earned between effective_start_date and effective_end_date
1897: and legislation_code = 'NL';
1898:

Line 1909: pay_input_values_f INPUTV

1905: FROM
1906: pay_element_entry_values_f EEV,
1907: pay_element_entries_f EE,
1908: pay_link_input_values_f LIV,
1909: pay_input_values_f INPUTV
1910: WHERE INPUTV.input_value_id = l_input_value_id
1911: AND p_date_earned BETWEEN INPUTV.effective_start_date AND INPUTV.effective_end_date
1912: AND INPUTV.element_type_id = l_element_type_id
1913: AND LIV.input_value_id = INPUTV.input_value_id