DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_ELEMENT_TYPES_F

Line 1260: PAY_ELEMENT_TYPES_F e,

1256: e.element_information_category earnings_lookup_type,
1257: e.classification_id,
1258: e.element_information1 earnings_category
1259: FROM PAY_ELEMENT_CLASSIFICATIONS c,
1260: PAY_ELEMENT_TYPES_F e,
1261: hr_organization_information hoi
1262: WHERE e.element_name = p_element_type
1263: AND (e.business_group_id = p_bg_id
1264: OR e.business_group_id IS NULL

Line 2025: PAY_ELEMENT_TYPES_F e,

2021:
2022: cursor get_element_details (p_element_type in varchar2,p_bg_id in number) is
2023: SELECT c.classification_name
2024: FROM PAY_ELEMENT_CLASSIFICATIONS c,
2025: PAY_ELEMENT_TYPES_F e,
2026: hr_organization_information hoi
2027: WHERE e.classification_id = c.classification_id
2028: AND hoi.organization_id = p_bg_id
2029: AND e.element_name = p_element_type