DBA Data[Home] [Help]

APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 573: hr_organization_information hoi

569: start with pose.organization_id_child = p_emp_org_id
570: and pose.org_structure_version_id = p_version
571: connect by prior pose.organization_id_parent = organization_id_child
572: ) org,
573: hr_organization_information hoi
574: where hoi.organization_id = org.organization_id_parent
575: and hoi.org_information1 = p_target_year
576: and hoi.org_information_context = 'KR_YEA_ENTRY_PERIOD_ORG'
577: group by organization_id_child, org.hierarchy_level

Line 585: from hr_organization_information hoi

581: cursor csr_bg_entry_period is
582: select min(fnd_date.canonical_to_date(hoi.org_information2)),
583: max(fnd_date.canonical_to_date(hoi.org_information3)),
584: max(fnd_date.canonical_to_date(hoi.org_information4))
585: from hr_organization_information hoi
586: where hoi.organization_id = p_business_group_id
587: and hoi.org_information1 = p_target_year
588: and hoi.org_information_context ='KR_YEA_ENTRY_PERIOD_BG';
589:

Line 595: from hr_organization_information hoi

591: cursor csr_emp_org_entry_period (p_emp_org number) is
592: select min(fnd_date.canonical_to_date(hoi.org_information2)),
593: max(fnd_date.canonical_to_date(hoi.org_information3)),
594: max(fnd_date.canonical_to_date(hoi.org_information4))
595: from hr_organization_information hoi
596: where hoi.organization_id = p_emp_org
597: and hoi.org_information1 = p_target_year
598: and hoi.org_information_context ='KR_YEA_ENTRY_PERIOD_ORG';
599: