APPS.PAY_NL_SI_PKG dependencies on PAY_INPUT_VALUES_F

Line 1561: l_input_value_id pay_input_values_f.input_value_id%TYPE;

1557: l_per_end_date DATE;
1558:
1559: --6887820
1560: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1561: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1562: l_prorate_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1563:
1564: --6887820
1565: CURSOR ele_typ_id

Line 1576: select input_value_id from pay_input_values_f

1572: and legislation_code = 'NL';
1573:
1574: CURSOR inp_val_id(p_element_type_id NUMBER)
1575: IS
1576: select input_value_id from pay_input_values_f
1577: where element_type_id = p_element_type_id
1578: and p_proration_start_date between effective_start_date and effective_end_date
1579: and legislation_code = 'NL';
1580:

Line 1591: pay_input_values_f INPUTV

1587: FROM
1588: pay_element_entry_values_f EEV,
1589: pay_element_entries_f EE,
1590: pay_link_input_values_f LIV,
1591: pay_input_values_f INPUTV
1592: WHERE INPUTV.input_value_id = l_input_value_id
1593: AND p_proration_start_date BETWEEN INPUTV.effective_start_date AND INPUTV.effective_end_date
1594: AND INPUTV.element_type_id = l_element_type_id
1595: AND LIV.input_value_id = INPUTV.input_value_id

Line 1826: l_input_value_id pay_input_values_f.input_value_id%TYPE;

1822: RETURN varchar2 IS
1823: l_override_si_days varchar2(35);
1824:
1825: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1826: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1827: l_prorate_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1828:
1829: --6887820
1830: CURSOR ele_typ_id

Line 1841: select input_value_id from pay_input_values_f

1837: and legislation_code = 'NL';
1838:
1839: CURSOR inp_val_id(p_element_type_id NUMBER)
1840: IS
1841: select input_value_id from pay_input_values_f
1842: where element_type_id = p_element_type_id
1843: and p_date_earned between effective_start_date and effective_end_date
1844: and legislation_code = 'NL';
1845:

Line 1856: pay_input_values_f INPUTV

1852: FROM
1853: pay_element_entry_values_f EEV,
1854: pay_element_entries_f EE,
1855: pay_link_input_values_f LIV,
1856: pay_input_values_f INPUTV
1857: WHERE INPUTV.input_value_id = l_input_value_id
1858: AND p_date_earned BETWEEN INPUTV.effective_start_date AND INPUTV.effective_end_date
1859: AND INPUTV.element_type_id = l_element_type_id
1860: AND LIV.input_value_id = INPUTV.input_value_id