APPS.PAY_US_SQWL_UDF dependencies on HR_ORGANIZATION_INFORMATION

Line 101: FROM hr_organization_information hoi

97: l_wage_plan_code VARCHAR2(1) := ' ';
98:
99: CURSOR c_gre_wage_plan IS
100: SELECT hoi.org_information3 wage_plan
101: FROM hr_organization_information hoi
102: WHERE hoi.org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
103: AND hoi.organization_id = p_tax_unit_id
104: AND hoi.org_information1 = p_transfer_state;
105:

Line 187: FROM hr_organization_information

183: p_information_context varchar2,
184: p_org_information1 varchar2
185: )IS
186: SELECT count(*) ct
187: FROM hr_organization_information
188: WHERE organization_id = p_organization_id
189: AND org_information_context = p_org_information_context
190: AND org_information1 = p_org_information1
191: AND org_information4 = 'Y';

Line 199: FROM hr_organization_information a

195: FROM (select distinct
196: a.organization_id,
197: a.org_information1,
198: a.org_information3
199: FROM hr_organization_information a
200: WHERE org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO') b
201: WHERE b.organization_id = p_organization_id
202: AND 1 < ( SELECT count(*)
203: FROM hr_organization_information orgi

Line 203: FROM hr_organization_information orgi

199: FROM hr_organization_information a
200: WHERE org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO') b
201: WHERE b.organization_id = p_organization_id
202: AND 1 < ( SELECT count(*)
203: FROM hr_organization_information orgi
204: WHERE organization_id = p_organization_id
205: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
206: AND org_information1 = b.org_information1
207: AND org_information3 = b.org_information3);

Line 318: FROM hr_organization_information target

314:
315:
316: CURSOR c_chk_govt_employer IS
317: SELECT target.ORG_INFORMATION8 yes_no
318: FROM hr_organization_information target
319: WHERE target.organization_id = l_tax_unit_id
320: AND target.org_information_context = 'Federal Tax Rules';
321:
322: --