APPS.PAY_US_SQWL_UDF dependencies on HR_ORGANIZATION_INFORMATION

Line 132: FROM hr_organization_information hoi

128: l_wage_plan_code VARCHAR2(1) := ' ';
129:
130: CURSOR c_gre_wage_plan IS
131: SELECT hoi.org_information3 wage_plan
132: FROM hr_organization_information hoi
133: WHERE hoi.org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
134: AND hoi.organization_id = p_tax_unit_id
135: AND hoi.org_information1 = p_transfer_state;
136:

Line 218: FROM hr_organization_information

214: p_information_context varchar2,
215: p_org_information1 varchar2
216: )IS
217: SELECT count(*) ct
218: FROM hr_organization_information
219: WHERE organization_id = p_organization_id
220: AND org_information_context = p_org_information_context
221: AND org_information1 = p_org_information1
222: AND org_information4 = 'Y';

Line 230: FROM hr_organization_information a

226: FROM (select distinct
227: a.organization_id,
228: a.org_information1,
229: a.org_information3
230: FROM hr_organization_information a
231: WHERE org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO') b
232: WHERE b.organization_id = p_organization_id
233: AND 1 < ( SELECT count(*)
234: FROM hr_organization_information orgi

Line 234: FROM hr_organization_information orgi

230: FROM hr_organization_information a
231: WHERE org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO') b
232: WHERE b.organization_id = p_organization_id
233: AND 1 < ( SELECT count(*)
234: FROM hr_organization_information orgi
235: WHERE organization_id = p_organization_id
236: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
237: AND org_information1 = b.org_information1
238: AND org_information3 = b.org_information3);

Line 349: FROM hr_organization_information target

345:
346:
347: CURSOR c_chk_govt_employer IS
348: SELECT target.ORG_INFORMATION8 yes_no
349: FROM hr_organization_information target
350: WHERE target.organization_id = l_tax_unit_id
351: AND target.org_information_context = 'Federal Tax Rules';
352:
353: --

Line 918: ,hr_organization_information hoi

914: from per_gen_hierarchy pgh
915: ,per_gen_hierarchy_versions pghv
916: ,per_gen_hierarchy_nodes pghn -- parent organization
917: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
918: ,hr_organization_information hoi
919: ,hr_organization_units hou
920: ,hr_locations loc
921: ,hr_location_extra_info lei
922: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(