APPS.PQH_FR_UTILITY dependencies on PER_SHARED_TYPES_VL

Line 425: From per_shared_types_vl

421: is
422:
423: Cursor csr_glb_shared_types Is
424: Select shared_type_id, shared_type_name
425: From per_shared_types_vl
426: Where lookup_type = p_lookup_type
427: And system_type_cd = p_lookup_code
428: And business_group_id is null;
429:

Line 432: From per_shared_types_vl

428: And business_group_id is null;
429:
430: Cursor csr_bg_shared_types is
431: Select shared_type_id, shared_type_name
432: From per_shared_types_vl
433: Where lookup_type = p_lookup_type
434: And system_type_cd = p_lookup_code
435: And business_group_id = p_business_group_id;
436:

Line 812: from pqh_fr_stat_situations_v sit , per_shared_types_vl sh

808: --
809: --
810: Cursor csr_situation_details IS
811: Select statutory_situation_id
812: from pqh_fr_stat_situations_v sit , per_shared_types_vl sh
813: where sh.shared_type_id = type_of_ps
814: and sh.system_type_cd = nvl(pqh_fr_utility.GET_BG_TYPE_OF_PS,sh.system_type_cd)
815: and sit.business_group_id = hr_general.get_business_group_id
816: and sit.default_flag = 'Y'

Line 1148: from per_shared_types_vl sh , hr_organization_information O

1144: IS
1145: --
1146: Cursor csr_get_bg_typ_of_ps IS
1147: Select System_type_cd
1148: from per_shared_types_vl sh , hr_organization_information O
1149: where O.org_information_context = 'FR_PQH_GROUPING_UNIT_INFO'
1150: and O.organization_id = hr_general.get_business_group_id
1151: and sh.shared_type_id = o.org_information1;
1152: --

Line 2039: FROM per_shared_types_vl

2035: ,p_return_value VARCHAR2) RETURN VARCHAR2 IS
2036: --
2037: CURSOR csr_glb_shared_types IS
2038: SELECT shared_type_id, shared_type_name
2039: FROM per_shared_types_vl
2040: WHERE lookup_type = 'FR_PQH_ORG_CATEGORY'
2041: AND system_type_cd = p_lookup_code
2042: AND business_group_id IS NULL;
2043: --

Line 2046: FROM per_shared_types_vl

2042: AND business_group_id IS NULL;
2043: --
2044: CURSOR csr_bg_shared_types IS
2045: SELECT shared_type_id, shared_type_name
2046: FROM per_shared_types_vl
2047: WHERE lookup_type = 'FR_PQH_ORG_CATEGORY'
2048: AND system_type_cd = p_lookup_code
2049: AND business_group_id = HR_GENERAL.get_business_group_id;
2050: --