APPS.PAY_HK_EXC dependencies on HR_ORGANIZATION_INFORMATION

Line 300: hr_organization_information HOI

296: ELSIF p_dimension_name like '%FQTD' THEN
297: SELECT fnd_date.canonical_to_date(org_information11)
298: INTO l_beg_of_fiscal_year
299: FROM pay_payroll_actions PACT,
300: hr_organization_information HOI
301: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
302: AND HOI.organization_id = PACT.business_group_id
303: AND PACT.payroll_action_id = p_owner_payroll_action_id;
304:

Line 312: hr_organization_information HOI

308: ELSIF p_dimension_name like '%FYTD' THEN
309: SELECT fnd_date.canonical_to_date(org_information11)
310: INTO l_beg_of_fiscal_year
311: FROM pay_payroll_actions PACT,
312: hr_organization_information HOI
313: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
314: AND HOI.organization_id = PACT.business_group_id
315: AND PACT.payroll_action_id = p_owner_payroll_action_id;
316:

Line 432: hr_organization_information HOI

428: ELSIF l_dimension_name like '%FQTD' THEN
429: SELECT fnd_date.canonical_to_date(org_information11)
430: INTO l_beg_of_fiscal_year
431: FROM pay_payroll_actions PACT,
432: hr_organization_information HOI
433: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
434: AND HOI.organization_id = PACT.business_group_id
435: AND PACT.payroll_action_id = l_payroll_action_id;
436:

Line 443: hr_organization_information HOI

439: ELSIF l_dimension_name like '%FYTD' THEN
440: SELECT fnd_date.canonical_to_date(org_information11)
441: INTO l_beg_of_fiscal_year
442: FROM pay_payroll_actions PACT,
443: hr_organization_information HOI
444: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
445: AND HOI.organization_id = PACT.business_group_id
446: AND PACT.payroll_action_id = l_payroll_action_id;
447:

Line 577: hr_organization_information HOI

573: ELSIF p_dimension_name like '%FQTD' THEN
574: SELECT fnd_date.canonical_to_date(org_information11)
575: INTO l_beg_of_fiscal_year
576: FROM pay_payroll_actions PACT,
577: hr_organization_information HOI
578: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
579: AND HOI.organization_id = PACT.business_group_id
580: AND PACT.payroll_action_id = p_owner_payroll_action_id;
581: p_expiry_date := next_fiscal_quarter(l_beg_of_fiscal_year,p_owner_effective_date) - 1;

Line 588: hr_organization_information HOI

584: ELSIF p_dimension_name like '%FYTD' THEN
585: SELECT fnd_date.canonical_to_date(org_information11)
586: INTO l_beg_of_fiscal_year
587: FROM pay_payroll_actions PACT,
588: hr_organization_information HOI
589: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
590: AND HOI.organization_id = PACT.business_group_id
591: AND PACT.payroll_action_id = p_owner_payroll_action_id;
592: