DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1408: FROM PAY_ELEMENT_CLASSIFICATIONS c,

1404: c.classification_name,
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

Line 2540: FROM PAY_ELEMENT_CLASSIFICATIONS c,

2536: l_sd_cty_or_cnt_exempt VARCHAR2(1) :='Y'; --# Bug13634961 added new variable l_sd_cty_or_cnt_exempt
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