APPS.PYUSEXC dependencies on HR_ORGANIZATION_INFORMATION

Line 265: hr_organization_information HOI

261: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
262: SELECT fnd_date.canonical_to_date(org_information11)
263: INTO l_beg_of_fiscal_year
264: FROM pay_payroll_actions PACT,
265: hr_organization_information HOI
266: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
267: AND HOI.organization_id = PACT.business_group_id
268: AND PACT.payroll_action_id = p_owner_payroll_action_id;
269:

Line 277: hr_organization_information HOI

273: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
274: SELECT fnd_date.canonical_to_date(org_information11)
275: INTO l_beg_of_fiscal_year
276: FROM pay_payroll_actions PACT,
277: hr_organization_information HOI
278: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
279: AND HOI.organization_id = PACT.business_group_id
280: AND PACT.payroll_action_id = p_owner_payroll_action_id;
281:

Line 358: hr_organization_information HOI

354: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
355: SELECT fnd_date.canonical_to_date(org_information11)
356: INTO l_beg_of_fiscal_year
357: FROM pay_payroll_actions PACT,
358: hr_organization_information HOI
359: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
360: AND HOI.organization_id = PACT.business_group_id
361: AND PACT.payroll_action_id = p_owner_payroll_action_id;
362:

Line 370: hr_organization_information HOI

366: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
367: SELECT fnd_date.canonical_to_date(org_information11)
368: INTO l_beg_of_fiscal_year
369: FROM pay_payroll_actions PACT,
370: hr_organization_information HOI
371: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
372: AND HOI.organization_id = PACT.business_group_id
373: AND PACT.payroll_action_id = p_owner_payroll_action_id;
374: