APPS.PAY_US_941_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 109: hr_organization_information hoi_bg,

105: hrl.town_or_city,
106: hrl.region_2,
107: hrl.postal_code
108: FROM hr_organization_units hou,
109: hr_organization_information hoi_bg,
110: hr_organization_information hoi_ein ,
111: hr_locations hrl
112: WHERE hou.organization_id = cp_tax_unit_id
113: AND hoi_bg.organization_id = hou.organization_id

Line 110: hr_organization_information hoi_ein ,

106: hrl.region_2,
107: hrl.postal_code
108: FROM hr_organization_units hou,
109: hr_organization_information hoi_bg,
110: hr_organization_information hoi_ein ,
111: hr_locations hrl
112: WHERE hou.organization_id = cp_tax_unit_id
113: AND hoi_bg.organization_id = hou.organization_id
114: and hoi_bg.org_information_context = 'CLASS'

Line 167: FROM HR_ORGANIZATION_INFORMATION_V

163:
164: --******** State Abbreviation (declarations start)
165: /* CURSOR c_state_abbr(cp_tax_unit_id IN number) IS
166: SELECT ORG_INFORMATION1
167: FROM HR_ORGANIZATION_INFORMATION_V
168: WHERE org_information_context = 'State Tax Rules'
169: AND ORGANIZATION_ID = cp_tax_unit_id;
170: ln_count_state NUMBER;
171: lv_STATE_ABBR_1 VARCHAR2(1);

Line 252: FROM HR_ORGANIZATION_INFORMATION_V

248:
249: -- State Abbreviation
250: /* SELECT count(DISTINCT(ORG_INFORMATION1))
251: INTO ln_count_state
252: FROM HR_ORGANIZATION_INFORMATION_V
253: WHERE org_information_context = 'State Tax Rules'
254: AND ORGANIZATION_ID = p_tax_unit_id;
255:
256: IF ln_count_state > 1 THEN