APPS.PYUSEXC dependencies on HR_ORGANIZATION_INFORMATION

Line 325: hr_organization_information HOI

321: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
322: SELECT fnd_date.canonical_to_date(org_information11)
323: INTO l_beg_of_fiscal_year
324: FROM pay_payroll_actions PACT,
325: hr_organization_information HOI
326: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
327: AND HOI.organization_id = PACT.business_group_id
328: AND PACT.payroll_action_id = p_owner_payroll_action_id;
329:

Line 337: hr_organization_information HOI

333: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
334: SELECT fnd_date.canonical_to_date(org_information11)
335: INTO l_beg_of_fiscal_year
336: FROM pay_payroll_actions PACT,
337: hr_organization_information HOI
338: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
339: AND HOI.organization_id = PACT.business_group_id
340: AND PACT.payroll_action_id = p_owner_payroll_action_id;
341:

Line 418: hr_organization_information HOI

414: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
415: SELECT fnd_date.canonical_to_date(org_information11)
416: INTO l_beg_of_fiscal_year
417: FROM pay_payroll_actions PACT,
418: hr_organization_information HOI
419: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
420: AND HOI.organization_id = PACT.business_group_id
421: AND PACT.payroll_action_id = p_owner_payroll_action_id;
422:

Line 430: hr_organization_information HOI

426: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
427: SELECT fnd_date.canonical_to_date(org_information11)
428: INTO l_beg_of_fiscal_year
429: FROM pay_payroll_actions PACT,
430: hr_organization_information HOI
431: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
432: AND HOI.organization_id = PACT.business_group_id
433: AND PACT.payroll_action_id = p_owner_payroll_action_id;
434: