APPS.PAY_CA_MAG_ROE dependencies on PER_ASSIGNMENTS_F

Line 142: per_assignments_f paf,

138: for one employee. */
139:
140: if p_person_id is not null then
141: p_sqlstr := 'select distinct person_id from
142: per_assignments_f paf,
143: ff_archive_items fai,
144: pay_payroll_actions ppa,
145: pay_assignment_actions paa
146: where

Line 161: per_assignments_f paf,

157: paf.effective_end_date and
158: person_id = '|| p_person_id;
159: elsif p_assignment_set is not null then
160: p_sqlstr := 'select distinct paf.person_id from
161: per_assignments_f paf,
162: ff_archive_items fai,
163: pay_payroll_actions ppa,
164: pay_assignment_actions paa,
165: HR_ASSIGNMENT_SET_AMENDMENTS haa

Line 183: per_assignments_f paf,

179: haa.include_or_exclude = ''I'' and
180: haa.assignment_set_id = '|| p_assignment_set;
181: else
182: p_sqlstr := 'select distinct person_id from
183: per_assignments_f paf,
184: ff_archive_items fai,
185: pay_payroll_actions ppa,
186: pay_assignment_actions paa
187: where

Line 259: -- per_assignments_f is not joined by date as there is

255:
256: lockingactid number;
257:
258: --
259: -- per_assignments_f is not joined by date as there is
260: -- a distinct in the select clause.
261: --
262: cursor cur_assignment_action is
263: select

Line 272: per_assignments_f paf

268: pay_payroll_actions ppa,
269: pay_assignment_actions paa,
270: ff_archive_items fai1,
271: ff_archive_items fai2,
272: per_assignments_f paf
273: where
274: ppa.report_type = 'ROE' and
275: ppa.report_category = 'ROEC' and
276: ppa.report_qualifier = 'ROEQ' and

Line 304: per_assignments_f paf,

300: pay_payroll_actions ppa,
301: pay_assignment_actions paa,
302: ff_archive_items fai1,
303: ff_archive_items fai2,
304: per_assignments_f paf,
305: pay_population_ranges ppr
306: where
307: ppa.report_type = 'ROE' and
308: ppa.report_category = 'ROEC' and