eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_FR_UTILITY dependencies on PER_SHARED_TYPES

Line 312: FROM per_shared_types

308: p_item_type Varchar2) RETURN NUMBER IS
309:
310: CURSOR C_Acco_Item IS
311: SELECT information2
312: FROM per_shared_types
313: WHERE lookup_type = 'FR_PQH_ENTITLEMENT_SETUP'
314: AND system_type_cd = 'ACCOMMODATION'
315: AND (business_group_id = p_business_group_id OR business_group_id IS NULL);
316:

Line 319: FROM per_shared_types

315: AND (business_group_id = p_business_group_id OR business_group_id IS NULL);
316:
317: CURSOR C_Ministry_Item IS
318: SELECT information2
319: FROM per_shared_types
320: WHERE lookup_type = 'FR_PQH_ENTITLEMENT_SETUP'
321: AND system_type_cd = 'MINISTRY_AWARD'
322: AND (business_group_id = p_business_group_id OR business_group_id IS NULL);
323:

Line 326: FROM per_shared_types

322: AND (business_group_id = p_business_group_id OR business_group_id IS NULL);
323:
324: CURSOR C_National_Item IS
325: SELECT information2
326: FROM per_shared_types
327: WHERE lookup_type = 'FR_PQH_ENTITLEMENT_SETUP'
328: AND system_type_cd = 'NATIONAL_AWARD'
329: AND (business_group_id = p_business_group_id OR business_group_id IS NULL);
330: l_entitlement_item NUMBER(15);

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 699: FROM per_shared_types

695: IS
696: CURSOR cur_bg_salary_share
697: IS
698: SELECT information1
699: FROM per_shared_types
700: WHERE lookup_type = 'FR_PQH_PHYSICAL_SHARE'
701: AND business_group_id = hr_general.get_business_group_id
702: AND system_type_cd = p_shard_type_cd;
703:

Line 707: FROM per_shared_types

703:
704: CURSOR global_salary_share
705: IS
706: SELECT information1
707: FROM per_shared_types
708: WHERE lookup_type = 'FR_PQH_PHYSICAL_SHARE'
709: AND business_group_id IS NULL
710: AND system_type_cd = p_shard_type_cd;
711:

Line 712: l_salary_share per_shared_types.information1%TYPE;

708: WHERE lookup_type = 'FR_PQH_PHYSICAL_SHARE'
709: AND business_group_id IS NULL
710: AND system_type_cd = p_shard_type_cd;
711:
712: l_salary_share per_shared_types.information1%TYPE;
713: BEGIN
714: OPEN cur_bg_salary_share;
715:
716: FETCH cur_bg_salary_share

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 1200: per_shared_types pst

1196: nvl(scl.segment19,'-999') reason,
1197: nvl(scl.segment9,'-999') share_part
1198: FROM per_all_assignments_f asg,
1199: hr_soft_coding_keyflex scl,
1200: per_shared_types pst
1201: WHERE asg.assignment_id = p_assignment_id
1202: AND pst.shared_type_id(+) = scl.segment9
1203: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id(+)
1204: and (effective_start_date = p_start_date

Line 1715: per_shared_types pst

1711: nvl(scl.segment9,'-999') share_part,
1712: asg.effective_end_date effective_end_date
1713: FROM per_all_assignments_f asg,
1714: hr_soft_coding_keyflex scl,
1715: per_shared_types pst
1716: WHERE asg.assignment_id = p_assignment_id
1717: AND pst.shared_type_id(+) = scl.segment9
1718: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id(+)
1719: and (effective_start_date = p_start_date

Line 1998: FROM per_shared_types

1994: --
1995: --Cursor to fetch Type Of PS Information1 for BG Org.
1996: CURSOR csr_ps_info IS
1997: SELECT information1
1998: FROM per_shared_types
1999: WHERE lookup_type = 'FR_PQH_ORG_CATEGORY'
2000: AND shared_type_id =(SELECT org_information1
2001: FROM hr_organization_information
2002: WHERE org_information_context = 'FR_PQH_GROUPING_UNIT_INFO'

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: --