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_CA_MAG_ROE dependencies on FF_ARCHIVE_ITEMS

Line 143: ff_archive_items fai,

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
147: fai.user_entity_id = ' || l_roe_date_uid || ' and

Line 162: ff_archive_items fai,

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
166: where

Line 184: ff_archive_items fai,

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
188: fai.user_entity_id = ' || l_roe_date_uid || ' and

Line 240: l_roe_date_id ff_archive_items.user_entity_id%TYPE;

236: p_start_date date;
237: p_end_date date;
238: p_person_id varchar2(10);
239:
240: l_roe_date_id ff_archive_items.user_entity_id%TYPE;
241: l_roe_assignment_id
242: ff_archive_items.user_entity_id%TYPE;
243: l_roe_gre_id
244: ff_archive_items.user_entity_id%TYPE;

Line 242: ff_archive_items.user_entity_id%TYPE;

238: p_person_id varchar2(10);
239:
240: l_roe_date_id ff_archive_items.user_entity_id%TYPE;
241: l_roe_assignment_id
242: ff_archive_items.user_entity_id%TYPE;
243: l_roe_gre_id
244: ff_archive_items.user_entity_id%TYPE;
245: l_roe_payroll_id
246: ff_archive_items.user_entity_id%TYPE;

Line 244: ff_archive_items.user_entity_id%TYPE;

240: l_roe_date_id ff_archive_items.user_entity_id%TYPE;
241: l_roe_assignment_id
242: ff_archive_items.user_entity_id%TYPE;
243: l_roe_gre_id
244: ff_archive_items.user_entity_id%TYPE;
245: l_roe_payroll_id
246: ff_archive_items.user_entity_id%TYPE;
247: l_assignment_id pay_assignment_actions.assignment_id%type;
248: l_gre_id pay_assignment_actions.tax_unit_id%type;

Line 246: ff_archive_items.user_entity_id%TYPE;

242: ff_archive_items.user_entity_id%TYPE;
243: l_roe_gre_id
244: ff_archive_items.user_entity_id%TYPE;
245: l_roe_payroll_id
246: ff_archive_items.user_entity_id%TYPE;
247: l_assignment_id pay_assignment_actions.assignment_id%type;
248: l_gre_id pay_assignment_actions.tax_unit_id%type;
249: l_payroll_id ff_archive_items.value%type;
250:

Line 249: l_payroll_id ff_archive_items.value%type;

245: l_roe_payroll_id
246: ff_archive_items.user_entity_id%TYPE;
247: l_assignment_id pay_assignment_actions.assignment_id%type;
248: l_gre_id pay_assignment_actions.tax_unit_id%type;
249: l_payroll_id ff_archive_items.value%type;
250:
251: cursor cur_assignment_action_id is
252: select pay_assignment_actions_s.nextval
253: from dual;

Line 270: ff_archive_items fai1,

266: fai2.value payroll_id
267: from
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

Line 271: ff_archive_items fai2,

267: from
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

Line 302: ff_archive_items fai1,

298: fai2.value payroll_id
299: from
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

Line 303: ff_archive_items fai2,

299: from
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

Line 327: cursor cur_locked_action_id(l_assignment_id ff_archive_items.value%TYPE,

323: ppr.payroll_action_id = p_pactid
324: AND ppr.chunk_number = p_chunk
325: AND paf.person_id = ppr.person_id;
326:
327: cursor cur_locked_action_id(l_assignment_id ff_archive_items.value%TYPE,
328: l_gre_id ff_archive_items.value%TYPE,
329: l_payroll_id ff_archive_items.value%TYPE) is
330: select
331: paa.assignment_action_id locked_action_id

Line 328: l_gre_id ff_archive_items.value%TYPE,

324: AND ppr.chunk_number = p_chunk
325: AND paf.person_id = ppr.person_id;
326:
327: cursor cur_locked_action_id(l_assignment_id ff_archive_items.value%TYPE,
328: l_gre_id ff_archive_items.value%TYPE,
329: l_payroll_id ff_archive_items.value%TYPE) is
330: select
331: paa.assignment_action_id locked_action_id
332: from

Line 329: l_payroll_id ff_archive_items.value%TYPE) is

325: AND paf.person_id = ppr.person_id;
326:
327: cursor cur_locked_action_id(l_assignment_id ff_archive_items.value%TYPE,
328: l_gre_id ff_archive_items.value%TYPE,
329: l_payroll_id ff_archive_items.value%TYPE) is
330: select
331: paa.assignment_action_id locked_action_id
332: from
333: pay_payroll_actions ppa,

Line 335: ff_archive_items fai1,

331: paa.assignment_action_id locked_action_id
332: from
333: pay_payroll_actions ppa,
334: pay_assignment_actions paa,
335: ff_archive_items fai1,
336: ff_archive_items fai2
337: where
338: ppa.report_type = 'ROE' and
339: ppa.report_category = 'ROEC' and

Line 336: ff_archive_items fai2

332: from
333: pay_payroll_actions ppa,
334: pay_assignment_actions paa,
335: ff_archive_items fai1,
336: ff_archive_items fai2
337: where
338: ppa.report_type = 'ROE' and
339: ppa.report_category = 'ROEC' and
340: ppa.report_qualifier = 'ROEQ' and