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_PDS_BUS dependencies on PER_ASSIGNMENTS_F

Line 121: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

117: ) is
118: --
119: l_api_updating boolean;
120: l_no_data_found boolean;
121: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
122: l_assignment_id per_assignments_f.assignment_id%TYPE;
123: l_proc varchar2(72) :=
124: g_package||'chk_actual_termination_date';
125: --

Line 122: l_assignment_id per_assignments_f.assignment_id%TYPE;

118: --
119: l_api_updating boolean;
120: l_no_data_found boolean;
121: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
122: l_assignment_id per_assignments_f.assignment_id%TYPE;
123: l_proc varchar2(72) :=
124: g_package||'chk_actual_termination_date';
125: --
126: cursor csr_get_max_asg_start_date is

Line 129: from per_assignments_f asg

125: --
126: cursor csr_get_max_asg_start_date is
127: select min(asg.effective_start_date)
128: , asg.assignment_id
129: from per_assignments_f asg
130: where asg.period_of_service_id = p_period_of_service_id
131: group by asg.assignment_id
132: order by 1 desc;
133: --