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

Line 287: from per_assignments_f asg

283: if ln_person_id is not null then
284:
285: lv_sql_string :=
286: 'select distinct asg.person_id person_id
287: from per_assignments_f asg
288: where person_id = ' || ln_person_id ||
289: ' and :payroll_action_id > 0';
290:
291: hr_utility.trace('Range for person_id not null');

Line 298: per_assignments_f paf

294:
295: lv_sql_string :=
296: 'select distinct paf.person_id
297: from hr_assignment_set_amendments asgset,
298: per_assignments_f paf
299: where assignment_set_id = ' || ln_asg_set || '
300: and asgset.assignment_id = paf.assignment_id
301: and asgset.include_or_exclude = ''I''
302: and :payroll_action_id > 0

Line 313: per_assignments_f paf,

309: lv_sql_string :=
310: 'select distinct paf.person_id
311: from pay_payroll_actions ppa_rep,
312: pay_assignment_actions paa_rep,
313: per_assignments_f paf,
314: pay_payroll_actions ppa
315: where paa_rep.assignment_id = paf.assignment_id
316: and ppa.payroll_action_id = :payroll_action_id
317: and ppa_rep.business_group_id = ppa.business_group_id

Line 331: per_assignments_f paf,

327: lv_sql_string :=
328: 'select distinct paf.person_id
329: from pay_payroll_actions ppa_rep,
330: pay_assignment_actions paa_rep,
331: per_assignments_f paf,
332: pay_payroll_actions ppa
333: where paa_rep.assignment_id = paf.assignment_id
334: and ppa.payroll_action_id = :payroll_action_id
335: and ppa_rep.business_group_id = ppa.business_group_id

Line 422: per_assignments_f paf,

418: ,cp_asg_set in number
419: ,cp_effective_date in date) is
420: select distinct paf.person_id
421: from hr_assignment_set_amendments asgset,
422: per_assignments_f paf,
423: pay_payroll_actions ppa,
424: pay_assignment_actions paa
425: where asgset.assignment_set_id = cp_asg_set
426: and asgset.include_or_exclude = 'I'

Line 445: per_assignments_f paf,

441: ,cp_asg_set in number
442: ,cp_effective_date in date) is
443: select distinct paf.person_id
444: from hr_assignment_set_amendments asgset,
445: per_assignments_f paf,
446: pay_payroll_actions ppa,
447: pay_assignment_actions paa,
448: pay_population_ranges ppr
449: where asgset.assignment_set_id = cp_asg_set

Line 496: per_assignments_f paf

492: cp_end_person number) is
493: select distinct paf.person_id
494: from pay_payroll_actions ppa_rep,
495: pay_assignment_actions paa_rep,
496: per_assignments_f paf
497: where ppa_rep.business_group_id = cp_bg_id
498: and ppa_rep.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
499: and ppa_rep.report_qualifier = 'DEFAULT'
500: and ppa_rep.effective_date = cp_eff_date

Line 519: per_assignments_f paf,

515: cp_end_person number) is
516: select distinct paf.person_id
517: from pay_payroll_actions ppa_rep,
518: pay_assignment_actions paa_rep,
519: per_assignments_f paf,
520: pay_population_ranges ppr
521: where ppa_rep.business_group_id = cp_bg_id
522: and ppa_rep.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
523: and ppa_rep.report_qualifier = 'DEFAULT'

Line 550: per_assignments_f paf

546: paa.serial_number,
547: paf.effective_end_date
548: from pay_payroll_actions ppa,
549: pay_assignment_actions paa,
550: per_assignments_f paf
551: where paf.person_id = to_char(cp_person_id)
552: and paf.assignment_id = paa.assignment_id
553: and paf.effective_start_date <= cp_effective_date
554: and paf.effective_end_date >= trunc(cp_effective_date,'Y')

Line 605: per_assignments_f paf

601: paa.serial_number,
602: paf.effective_end_date
603: from pay_payroll_actions ppa,
604: pay_assignment_actions paa,
605: per_assignments_f paf
606: where paf.person_id = to_char(cp_person_id)
607: and paf.assignment_id = paa.assignment_id
608: and paf.effective_start_date <= cp_effective_date
609: and paf.effective_end_date >= trunc(cp_effective_date,'Y')

Line 657: per_assignments_f paf,

653: paa.serial_number,
654: paf.effective_end_date
655: from pay_payroll_actions ppa,
656: pay_assignment_actions paa,
657: per_assignments_f paf,
658: per_periods_of_service pds
659: where paf.person_id = to_char(cp_person_id)
660: and paf.assignment_id = paa.assignment_id
661: and paf.effective_start_date <= cp_effective_date

Line 715: per_assignments_f paf,

711: paa.serial_number,
712: paf.effective_end_date
713: from pay_payroll_actions ppa,
714: pay_assignment_actions paa,
715: per_assignments_f paf,
716: per_periods_of_service pds
717: where paf.person_id = to_char(cp_person_id)
718: and paf.assignment_id = paa.assignment_id
719: and paf.effective_start_date <= cp_effective_date

Line 1367: l_per_id per_assignments_f.person_id%type;

1363:
1364: l_dt date;
1365: l_year number ;
1366: l_pre_id pay_assignment_actions.tax_unit_id%type;
1367: l_per_id per_assignments_f.person_id%type;
1368: l_sort1 varchar2(60);
1369: l_sort2 varchar2(60);
1370: l_sort3 varchar2(60);
1371: l_year_start date;