APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_INPUT_VALUES_F

Line 334: FROM pay_input_values_f i

330:
331: CURSOR csr_inputs(v_element_type_id IN NUMBER,
332: v_input_name IN VARCHAR2) IS
333: SELECT i.input_value_id
334: FROM pay_input_values_f i
335: WHERE i.element_type_id = v_element_type_id
336: AND (i.business_group_id = p_bg_id
337: OR i.business_group_id IS NULL)
338: AND upper(i.name) = upper(v_input_name)

Line 1443: PAY_INPUT_VALUES_F i

1439: 'D', fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_adjustment_date)),
1440: 'ND', To_Char(p_adjustment_date, 'Day')))
1441: ) default_value
1442: FROM HR_LOOKUPS hr,
1443: PAY_INPUT_VALUES_F i
1444: WHERE i.element_type_id = v_element_type_id
1445: AND i.mandatory_flag = 'Y'
1446: AND i.default_value = hr.lookup_code (+)
1447: AND i.lookup_type = hr.lookup_type (+)

Line 1462: l_input_value_id pay_input_values_f.input_value_id%TYPE := NULL;

1458: l_payroll_action_id NUMBER;
1459:
1460: /* Bug#9796821 - Starts */
1461: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
1462: l_input_value_id pay_input_values_f.input_value_id%TYPE := NULL;
1463: l_medi_ee_limit1 NUMBER := 0;
1464: l_medicare_taxability VARCHAR2(1) := NULL;
1465: l_excess NUMBER := 0;
1466: l_value NUMBER := 0;

Line 1961: pay_input_values_f piv

1957: BEGIN
1958: SELECT pet.element_type_id, piv.input_value_id
1959: INTO l_element_type_id, l_input_value_id
1960: FROM pay_element_types_f pet,
1961: pay_input_values_f piv
1962: WHERE pet.element_name = 'Medicare_EE_Over_Limit'
1963: AND piv.element_type_id = pet.element_type_id
1964: AND piv.name = 'TAXABLE'
1965: AND pet.business_group_id IS NULL