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.PAY_NL_GENERAL dependencies on PER_ASSIGNMENTS_F

Line 127: from per_assignments_f asg,

123:
124: cursor csr_asg_dates is
125: select min(asg.effective_start_date) asg_start_date
126: ,max(asg.effective_end_date) asg_end_date
127: from per_assignments_f asg,
128: per_assignment_status_types past
129: where asg.assignment_id = p_assignment_id
130: and past.per_system_status = 'ACTIVE_ASSIGN'
131: and asg.assignment_status_type_id = past.assignment_status_type_id

Line 137: from per_assignments_f asg,

133: and nvl(asg.effective_end_date, p_period_end_date) >= p_period_start_date;
134:
135: cursor csr_asg_act_dates (p_date date) is
136: select asg.effective_end_date
137: from per_assignments_f asg,
138: per_assignment_status_types past
139: where asg.assignment_id = p_assignment_id
140: and past.per_system_status = 'ACTIVE_ASSIGN'
141: and asg.assignment_status_type_id = past.assignment_status_type_id