APPS.PAY_NL_SI_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1577: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1573: l_per_start_date DATE;
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

Line 1585: from pay_element_types_f

1581: --6887820
1582: CURSOR ele_typ_id
1583: IS
1584: select element_type_id
1585: from pay_element_types_f
1586: where
1587: element_name = 'NL Tax and SI Proration Indicator'
1588: and p_proration_start_date between effective_start_date and effective_end_date
1589: and legislation_code = 'NL';

Line 1878: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1874: )
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

Line 1886: from pay_element_types_f

1882: --6887820
1883: CURSOR ele_typ_id
1884: IS
1885: select element_type_id
1886: from pay_element_types_f
1887: where
1888: element_name = 'NL Tax and SI Proration Indicator'
1889: and p_date_earned between effective_start_date and effective_end_date
1890: and legislation_code = 'NL';