APPS.PER_PGV_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 942: , p_business_group_id IN hr_all_organization_units.business_group_id%TYPE

938: (p_date_from IN per_gen_hierarchy_versions.date_from%TYPE
939: , p_date_to IN per_gen_hierarchy_versions.date_to%TYPE
940: , p_hierarchy_version_id IN per_gen_hierarchy_versions.hierarchy_version_id%TYPE
941: , p_hierarchy_id IN per_gen_hierarchy_versions.hierarchy_id%TYPE
942: , p_business_group_id IN hr_all_organization_units.business_group_id%TYPE
943: , p_object_version_number IN per_gen_hierarchy_versions.object_version_number%TYPE
944: ) IS
945: --
946: l_proc VARCHAR2(72) := g_package||'chk_date_from';

Line 952: FROM hr_all_organization_units

948: l_api_updating boolean;
949: --
950: CURSOR csr_date_between IS
951: SELECT 'Y'
952: FROM hr_all_organization_units
953: WHERE p_date_from >= date_from
954: AND (p_date_from <= date_to
955: OR date_to is null)
956: AND (business_group_id = p_business_group_id);

Line 1095: , p_business_group_id IN hr_all_organization_units.business_group_id%TYPE

1091: , p_date_from IN per_gen_hierarchy_versions.date_from%TYPE
1092: , p_hierarchy_version_id IN per_gen_hierarchy_versions.hierarchy_version_id%TYPE
1093: , p_hierarchy_id IN per_gen_hierarchy_versions.hierarchy_id%TYPE
1094: , p_version_number IN number
1095: , p_business_group_id IN hr_all_organization_units.business_group_id%TYPE
1096: , p_object_version_number IN per_gen_hierarchy_versions.object_version_number%TYPE
1097: ) IS
1098: --
1099: l_proc VARCHAR2(72) := g_package||'chk_date_to';

Line 1106: FROM hr_all_organization_units

1102: l_date_to date;
1103: --
1104: CURSOR csr_date_between IS
1105: SELECT 'Y'
1106: FROM hr_all_organization_units
1107: WHERE l_date_to >= date_from
1108: AND (l_date_to <= date_to
1109: OR date_to is null)
1110: AND (organization_id = p_business_group_id);