APPS.PAY_US_TAX_BALS_ADJ_API dependencies on HR_LOOKUPS

Line 1293: FROM HR_LOOKUPS hr,

1289: 'H_HHMMSS', '12:00:00',
1290: 'D', fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_adjustment_date)),
1291: 'ND', To_Char(p_adjustment_date, 'Day')))
1292: ) default_value
1293: FROM HR_LOOKUPS hr,
1294: PAY_INPUT_VALUES_F i
1295: WHERE i.element_type_id = v_element_type_id
1296: AND i.mandatory_flag = 'Y'
1297: AND i.default_value = hr.lookup_code (+)

Line 2089: hr_lookups hl

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
2093: and hl.lookup_type = 'US_SELF_ADJUST_METHOD';

Line 2099: hr_lookups hl

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
2103: and hl.lookup_type = 'US_SELF_ADJUST_METHOD';

Line 2109: hr_lookups hl

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
2113: and hl.lookup_type = 'MEDI_SELF_ADJ_CALC_METHOD';

Line 2119: hr_lookups hl

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
2123: and hoi.org_information5 = hl.LOOKUP_CODE

Line 2130: hr_lookups hl

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
2134: and hoi.org_information4 = hl.LOOKUP_CODE --bug 3887144