APPS.PAY_US_941_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 199: hr_organization_information hoi_bg,

195: hrl.town_or_city,
196: hrl.region_2,
197: hrl.postal_code
198: FROM hr_organization_units hou,
199: hr_organization_information hoi_bg,
200: hr_organization_information hoi_ein ,
201: hr_locations hrl
202: WHERE hou.organization_id = cp_tax_unit_id
203: AND hoi_bg.organization_id = hou.organization_id

Line 200: hr_organization_information hoi_ein ,

196: hrl.region_2,
197: hrl.postal_code
198: FROM hr_organization_units hou,
199: hr_organization_information hoi_bg,
200: hr_organization_information hoi_ein ,
201: hr_locations hrl
202: WHERE hou.organization_id = cp_tax_unit_id
203: AND hoi_bg.organization_id = hou.organization_id
204: and hoi_bg.org_information_context = 'CLASS'

Line 379: FROM HR_ORGANIZATION_INFORMATION_V

375:
376: --******** State Abbreviation (declarations start)
377: /* CURSOR c_state_abbr(cp_tax_unit_id IN number) IS
378: SELECT ORG_INFORMATION1
379: FROM HR_ORGANIZATION_INFORMATION_V
380: WHERE org_information_context = 'State Tax Rules'
381: AND ORGANIZATION_ID = cp_tax_unit_id;
382: ln_count_state NUMBER;
383: lv_STATE_ABBR_1 VARCHAR2(1);

Line 570: FROM HR_ORGANIZATION_INFORMATION_V

566:
567: -- State Abbreviation
568: /* SELECT count(DISTINCT(ORG_INFORMATION1))
569: INTO ln_count_state
570: FROM HR_ORGANIZATION_INFORMATION_V
571: WHERE org_information_context = 'State Tax Rules'
572: AND ORGANIZATION_ID = p_tax_unit_id;
573:
574: IF ln_count_state > 1 THEN