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.GHR_PA_REQUESTS_PKG2 dependencies on PER_SHARED_TYPES

Line 741: from hr_all_positions_f pos, per_shared_types typ

737: l_message_set BOOLEAN := FALSE;
738:
739: cursor cur_pos is
740: select pos.effective_start_date,pos.effective_end_date,typ.system_type_cd status
741: from hr_all_positions_f pos, per_shared_types typ
742: where p_effective_date
743: between pos.effective_start_date and pos.effective_end_date
744: and pos.business_group_id = p_business_group_id
745: and pos.position_id = p_position_id

Line 749: from hr_all_positions_f pos1, per_shared_types typ1

745: and pos.position_id = p_position_id
746: and pos.availability_status_id = typ.shared_type_id
747: union
748: select pos1.effective_start_date,pos1.effective_end_date,typ1.system_type_cd status
749: from hr_all_positions_f pos1, per_shared_types typ1
750: where p_effective_date <= pos1.effective_start_date
751: and pos1.business_group_id = p_business_group_id
752: and pos1.position_id = p_position_id
753: and pos1.availability_status_id = typ1.shared_type_id

Line 807: from hr_all_positions_f pos, per_shared_types typ

803: l_message_set BOOLEAN := FALSE;
804:
805: cursor cur_pos is
806: select effective_start_date,effective_end_date,system_type_cd status
807: from hr_all_positions_f pos, per_shared_types typ
808: where p_effective_date
809: between effective_start_date and effective_end_date
810: and position_id = p_position_id
811: and pos.business_group_id = p_business_group_id