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_UTILITY dependencies on HR_ALL_POSITIONS_F

Line 394: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,

390: ,P_SEGMENT30 in VARCHAR2
391: ,P_INFORMATION6 in VARCHAR2
392: ,P_EFFECTIVE_DATE in DATE
393: ,P_LANGUAGE_CODE in VARCHAR2 ) IS
394: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
395: c_effective_date date) is
396: select information6,segment1,segment2,segment3,segment4,
397: segment5,segment6,segment7
398: from per_position_definitions pdf, hr_all_positions_f pos

Line 398: from per_position_definitions pdf, hr_all_positions_f pos

394: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
395: c_effective_date date) is
396: select information6,segment1,segment2,segment3,segment4,
397: segment5,segment6,segment7
398: from per_position_definitions pdf, hr_all_positions_f pos
399: where pos.position_definition_id = pdf.position_definition_id
400: and pos.position_id = c_position_id
401: and c_effective_date between pos.effective_start_date and
402: pos.effective_end_date;

Line 544: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,

540: ,P_SEGMENT30 in VARCHAR2
541: ,P_INFORMATION6 in VARCHAR2
542: ,P_EFFECTIVE_DATE in DATE
543: ,P_LANGUAGE_CODE in VARCHAR2 ) IS
544: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
545: c_effective_date date) is
546: select information6,segment1,segment2,segment3,segment4,
547: segment5,segment6,segment7
548: from per_position_definitions pdf, hr_all_positions_f pos

Line 548: from per_position_definitions pdf, hr_all_positions_f pos

544: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
545: c_effective_date date) is
546: select information6,segment1,segment2,segment3,segment4,
547: segment5,segment6,segment7
548: from per_position_definitions pdf, hr_all_positions_f pos
549: where pos.position_definition_id = pdf.position_definition_id
550: and pos.position_id = c_position_id
551: and c_effective_date between pos.effective_start_date and
552: pos.effective_end_date;

Line 734: p_position_id in hr_all_positions_f.position_id%type default null,

730: END;
731:
732: PROCEDURE set_client_info
733: ( p_person_id in per_all_people_f.person_id%type default null,
734: p_position_id in hr_all_positions_f.position_id%type default null,
735: p_assignment_id in per_all_assignments_f.assignment_id%type default null)
736: is
737: cursor c_per_bus_group_id(p_person_id in per_all_people_f.person_id%TYPE) is
738: select ppf.business_group_id

Line 743: cursor c_pos_bus_group_id(p_position_id in hr_all_positions_f.position_id%TYPE ) is

739: from per_all_people_f ppf
740: where ppf.person_id = p_person_id
741: and trunc(sysdate) between ppf.effective_start_date
742: and ppf.effective_end_date;
743: cursor c_pos_bus_group_id(p_position_id in hr_all_positions_f.position_id%TYPE ) is
744: select pos.business_group_id
745: from hr_all_positions_f pos -- Venkat -- Position DT
746: where pos.position_id = p_position_id
747: and trunc(sysdate) between pos.effective_start_date

Line 745: from hr_all_positions_f pos -- Venkat -- Position DT

741: and trunc(sysdate) between ppf.effective_start_date
742: and ppf.effective_end_date;
743: cursor c_pos_bus_group_id(p_position_id in hr_all_positions_f.position_id%TYPE ) is
744: select pos.business_group_id
745: from hr_all_positions_f pos -- Venkat -- Position DT
746: where pos.position_id = p_position_id
747: and trunc(sysdate) between pos.effective_start_date
748: and pos.effective_end_date;
749: cursor c_asg_bus_group_id(