APPS.PAY_US_TAX_BALS_ADJ_API dependencies on HR_LOOKUPS

Line 1442: FROM HR_LOOKUPS hr,

1438: 'H_HHMMSS', '12:00:00',
1439: 'D', fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_adjustment_date)),
1440: 'ND', To_Char(p_adjustment_date, 'Day')))
1441: ) default_value
1442: FROM HR_LOOKUPS hr,
1443: PAY_INPUT_VALUES_F i
1444: WHERE i.element_type_id = v_element_type_id
1445: AND i.mandatory_flag = 'Y'
1446: AND i.default_value = hr.lookup_code (+)

Line 2628: hr_lookups hl

2624: Cursor c_get_futa_self_adjust_method
2625: IS
2626: select hl.meaning
2627: from hr_organization_information hoi,
2628: hr_lookups hl
2629: where hoi.organization_id = p_tax_unit_id
2630: and hoi.org_information_context = 'Federal Tax Rules'
2631: and hoi.org_information3 = hl.LOOKUP_CODE
2632: and hl.lookup_type = 'US_SELF_ADJUST_METHOD';

Line 2638: hr_lookups hl

2634: Cursor c_get_ss_self_adjust_method
2635: IS
2636: select hl.meaning
2637: from hr_organization_information hoi,
2638: hr_lookups hl
2639: where hoi.organization_id = p_tax_unit_id
2640: and hoi.org_information_context = 'Federal Tax Rules'
2641: and hoi.org_information1 = hl.LOOKUP_CODE
2642: and hl.lookup_type = 'US_SELF_ADJUST_METHOD';

Line 2648: hr_lookups hl

2644: Cursor c_get_medi_self_adjust_method
2645: IS
2646: select hl.meaning
2647: from hr_organization_information hoi,
2648: hr_lookups hl
2649: where hoi.organization_id = p_tax_unit_id
2650: and hoi.org_information_context = 'Federal Tax Rules'
2651: and hoi.org_information2 = hl.LOOKUP_CODE
2652: and hl.lookup_type = 'MEDI_SELF_ADJ_CALC_METHOD';

Line 2658: hr_lookups hl

2654: Cursor c_get_sdi_self_adjust_method
2655: IS
2656: select hl.meaning
2657: from hr_organization_information hoi,
2658: hr_lookups hl
2659: where hoi.organization_id = p_tax_unit_id
2660: and hoi.org_information_context = 'State Tax Rules'
2661: and hoi.org_information1 = p_state_abbrev
2662: and hoi.org_information5 = hl.LOOKUP_CODE

Line 2669: hr_lookups hl

2665: Cursor c_get_sdi1_self_adjust_method
2666: IS
2667: select hl.meaning
2668: from hr_organization_information hoi,
2669: hr_lookups hl
2670: where hoi.organization_id = p_tax_unit_id
2671: and hoi.org_information_context = 'State Tax Rules2'
2672: and hoi.org_information1 = p_state_abbrev
2673: and hoi.org_information5 = hl.LOOKUP_CODE

Line 2680: hr_lookups hl

2676: Cursor c_get_sui_self_adjust_method
2677: IS
2678: select hl.meaning
2679: from hr_organization_information hoi,
2680: hr_lookups hl
2681: where hoi.organization_id = p_tax_unit_id
2682: and hoi.org_information_context = 'State Tax Rules'
2683: and hoi.org_information1 = p_state_abbrev
2684: and hoi.org_information4 = hl.LOOKUP_CODE --bug 3887144