APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_ELEMENT_TYPES_F

Line 1409: PAY_ELEMENT_TYPES_F e,

1405: e.element_information_category earnings_lookup_type,
1406: e.classification_id,
1407: e.element_information1 earnings_category
1408: FROM PAY_ELEMENT_CLASSIFICATIONS c,
1409: PAY_ELEMENT_TYPES_F e,
1410: hr_organization_information hoi
1411: WHERE e.element_name = p_element_type
1412: AND (e.business_group_id = p_bg_id
1413: OR e.business_group_id IS NULL

Line 1461: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;

1457: l_counter NUMBER;
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;

Line 1960: FROM pay_element_types_f pet,

1956: /* Get the Element ID and TAXABLE Input Value ID of Medicare_EE_Over_Limit */
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'

Line 2541: PAY_ELEMENT_TYPES_F e,

2537:
2538: cursor get_element_details (p_element_type in varchar2,p_bg_id in number) is
2539: SELECT c.classification_name
2540: FROM PAY_ELEMENT_CLASSIFICATIONS c,
2541: PAY_ELEMENT_TYPES_F e,
2542: hr_organization_information hoi
2543: WHERE e.classification_id = c.classification_id
2544: AND hoi.organization_id = p_bg_id
2545: AND e.element_name = p_element_type