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.PER_ASG_BUS1 dependencies on HR_ALL_POSITIONS_F

Line 7433: from hr_all_positions_f

7429: order by 1,2 desc;
7430:
7431: cursor c_position_type is
7432: select position_type
7433: from hr_all_positions_f
7434: where position_id = p_position_id;
7435:
7436: cursor c3(lp_effective_end_date date) is
7437: select

Line 7467: l_position_type hr_all_positions_f.position_type%type;

7463:
7464: l_ol_effective_start_date date;
7465: l_ol_effective_end_date date;
7466:
7467: l_position_type hr_all_positions_f.position_type%type;
7468: l_asg_number per_all_assignments_f.assignment_number%type;
7469: l_asg_effective_start_date date;
7470: l_asg_effective_end_date date;
7471: -- End changes for bug 11828317

Line 7646: from hr_all_positions_f

7642: l_asg_in_overlap_dates boolean;
7643: --
7644: cursor c_position_type(p_position_id number, p_effective_date date) is
7645: select position_type, availability_status_id, business_group_id
7646: from hr_all_positions_f
7647: where position_id = p_position_id
7648: and p_effective_date between effective_start_date and effective_end_date;
7649: --
7650: begin