[Home] [Help]
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
1265: )
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
2030: AND (e.business_group_id = p_bg_id
2052: CURSOR c_get_tax_group IS
2053: select decode(hoi.org_information5,
2054: NULL,'NOT_ENTERED',
2055: hoi.org_information5)
2056: from hr_organization_information hoi
2057: where hoi.organization_id = p_tax_unit_id
2058: and hoi.org_information_context = 'Federal Tax Rules'
2059: ;
2060:
2084:
2085: Cursor c_get_futa_self_adjust_method
2086: IS
2087: select hl.meaning
2088: from hr_organization_information hoi,
2089: hr_lookups hl
2090: where hoi.organization_id = p_tax_unit_id
2091: and hoi.org_information_context = 'Federal Tax Rules'
2092: and hoi.org_information3 = hl.LOOKUP_CODE
2094:
2095: Cursor c_get_ss_self_adjust_method
2096: IS
2097: select hl.meaning
2098: from hr_organization_information hoi,
2099: hr_lookups hl
2100: where hoi.organization_id = p_tax_unit_id
2101: and hoi.org_information_context = 'Federal Tax Rules'
2102: and hoi.org_information1 = hl.LOOKUP_CODE
2104:
2105: Cursor c_get_medi_self_adjust_method
2106: IS
2107: select hl.meaning
2108: from hr_organization_information hoi,
2109: hr_lookups hl
2110: where hoi.organization_id = p_tax_unit_id
2111: and hoi.org_information_context = 'Federal Tax Rules'
2112: and hoi.org_information2 = hl.LOOKUP_CODE
2114:
2115: Cursor c_get_sdi_self_adjust_method
2116: IS
2117: select hl.meaning
2118: from hr_organization_information hoi,
2119: hr_lookups hl
2120: where hoi.organization_id = p_tax_unit_id
2121: and hoi.org_information_context = 'State Tax Rules'
2122: and hoi.org_information1 = p_state_abbrev
2125:
2126: Cursor c_get_sui_self_adjust_method
2127: IS
2128: select hl.meaning
2129: from hr_organization_information hoi,
2130: hr_lookups hl
2131: where hoi.organization_id = p_tax_unit_id
2132: and hoi.org_information_context = 'State Tax Rules'
2133: and hoi.org_information1 = p_state_abbrev