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 404: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,

400: ,P_SEGMENT30 in VARCHAR2
401: ,P_INFORMATION6 in VARCHAR2
402: ,P_EFFECTIVE_DATE in DATE
403: ,P_LANGUAGE_CODE in VARCHAR2 ) IS
404: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
405: c_effective_date date) is
406: select information6,segment1,segment2,segment3,segment4,
407: segment5,segment6,segment7
408: from per_position_definitions pdf, hr_all_positions_f pos

Line 408: from per_position_definitions pdf, hr_all_positions_f pos

404: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
405: c_effective_date date) is
406: select information6,segment1,segment2,segment3,segment4,
407: segment5,segment6,segment7
408: from per_position_definitions pdf, hr_all_positions_f pos
409: where pos.position_definition_id = pdf.position_definition_id
410: and pos.position_id = c_position_id
411: and c_effective_date between pos.effective_start_date and
412: pos.effective_end_date;

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

550: ,P_SEGMENT30 in VARCHAR2
551: ,P_INFORMATION6 in VARCHAR2
552: ,P_EFFECTIVE_DATE in DATE
553: ,P_LANGUAGE_CODE in VARCHAR2 ) IS
554: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
555: c_effective_date date) is
556: select information6,segment1,segment2,segment3,segment4,
557: segment5,segment6,segment7
558: from per_position_definitions pdf, hr_all_positions_f pos

Line 558: from per_position_definitions pdf, hr_all_positions_f pos

554: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
555: c_effective_date date) is
556: select information6,segment1,segment2,segment3,segment4,
557: segment5,segment6,segment7
558: from per_position_definitions pdf, hr_all_positions_f pos
559: where pos.position_definition_id = pdf.position_definition_id
560: and pos.position_id = c_position_id
561: and c_effective_date between pos.effective_start_date and
562: pos.effective_end_date;

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

747: END;
748:
749: PROCEDURE set_client_info
750: ( p_person_id in per_all_people_f.person_id%type default null,
751: p_position_id in hr_all_positions_f.position_id%type default null,
752: p_assignment_id in per_all_assignments_f.assignment_id%type default null)
753: is
754: cursor c_per_bus_group_id(p_person_id in per_all_people_f.person_id%TYPE) is
755: select ppf.business_group_id

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

756: from per_all_people_f ppf
757: where ppf.person_id = p_person_id
758: and trunc(sysdate) between ppf.effective_start_date
759: and ppf.effective_end_date;
760: cursor c_pos_bus_group_id(p_position_id in hr_all_positions_f.position_id%TYPE ) is
761: select pos.business_group_id
762: from hr_all_positions_f pos -- Venkat -- Position DT
763: where pos.position_id = p_position_id
764: and trunc(sysdate) between pos.effective_start_date

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

758: and trunc(sysdate) between ppf.effective_start_date
759: and ppf.effective_end_date;
760: cursor c_pos_bus_group_id(p_position_id in hr_all_positions_f.position_id%TYPE ) is
761: select pos.business_group_id
762: from hr_all_positions_f pos -- Venkat -- Position DT
763: where pos.position_id = p_position_id
764: and trunc(sysdate) between pos.effective_start_date
765: and pos.effective_end_date;
766: cursor c_asg_bus_group_id(