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.HR_APPROVAL_CUSTOM dependencies on PER_ALL_ASSIGNMENTS_F

Line 76: FROM per_all_assignments_f paf START WITH paf.person_id = p_person_id

72: return varchar2 is
73: --
74: cursor csr_pa(l_effective_date in date) is
75: SELECT paf.person_id
76: FROM per_all_assignments_f paf START WITH paf.person_id = p_person_id
77: AND paf.primary_flag = 'Y'
78: AND paf.assignment_type IN('E', 'C')
79: AND l_effective_date BETWEEN paf.effective_start_date
80: AND paf.effective_end_date

Line 131: ed_date per_all_assignments_f.effective_end_date%type;

127: end loop;
128: if p_forward_to_person_id = l_person_id then
129: ------------add extra check to block auto approval---------------
130: declare
131: ed_date per_all_assignments_f.effective_end_date%type;
132: l_disp_person_id per_all_assignments_f.person_id%type;
133: begin
134:
135: select nvl(max(ppf.EFFECTIVE_END_DATE),sysdate+10)

Line 132: l_disp_person_id per_all_assignments_f.person_id%type;

128: if p_forward_to_person_id = l_person_id then
129: ------------add extra check to block auto approval---------------
130: declare
131: ed_date per_all_assignments_f.effective_end_date%type;
132: l_disp_person_id per_all_assignments_f.person_id%type;
133: begin
134:
135: select nvl(max(ppf.EFFECTIVE_END_DATE),sysdate+10)
136: into ed_date

Line 139: from per_all_assignments_f paf1

135: select nvl(max(ppf.EFFECTIVE_END_DATE),sysdate+10)
136: into ed_date
137: from per_all_people_f ppf where ppf.person_id in (
138: select paf1.supervisor_id
139: from per_all_assignments_f paf1
140: where paf1.primary_flag = 'Y'
141: and paf1.assignment_type in ('E','C')
142: and paf1.person_id = l_person_id
143: and paf1.supervisor_id is not null

Line 145: from per_all_assignments_f paf

141: and paf1.assignment_type in ('E','C')
142: and paf1.person_id = l_person_id
143: and paf1.supervisor_id is not null
144: and paf1.EFFECTIVE_END_DATE = ( select max(paf.EFFECTIVE_END_DATE)
145: from per_all_assignments_f paf
146: where paf.primary_flag = 'Y'
147: and paf.assignment_type in ('E','C')
148: and paf.person_id = l_person_id
149: )

Line 157: from per_all_assignments_f paf1

153:
154: if ed_date < trunc(sysdate) then
155: select distinct paf1.supervisor_id
156: into l_disp_person_id
157: from per_all_assignments_f paf1
158: where paf1.primary_flag = 'Y'
159: and paf1.assignment_type in ('E','C')
160: and paf1.person_id = l_person_id
161: and paf1.supervisor_id is not null

Line 163: from per_all_assignments_f paf

159: and paf1.assignment_type in ('E','C')
160: and paf1.person_id = l_person_id
161: and paf1.supervisor_id is not null
162: and paf1.EFFECTIVE_END_DATE = ( select max(paf.EFFECTIVE_END_DATE)
163: from per_all_assignments_f paf
164: where paf.primary_flag = 'Y'
165: and paf.assignment_type in ('E','C')
166: and paf.person_id = l_person_id
167: );

Line 213: from per_all_assignments_f paf

209: /*
210: -- Modified the cursor to support Contingent Worker
211: -- Fix for bug#2949844
212: select ppf.person_id
213: from per_all_assignments_f paf
214: -- fix for bug # 1677216
215: --,per_people_f ppf
216: ,per_all_people_f ppf
217: where paf.person_id = l_in_person_id

Line 231: from per_all_assignments_f paf

227: */
228: -- modified cursor to handle the issues reported
229: -- in bug#3007859
230: select ppf.person_id
231: from per_all_assignments_f paf
232: ,per_all_people_f ppf
233: where paf.person_id = l_in_person_id
234: and paf.primary_flag = 'Y'
235: and trunc(sysdate)