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

Line 288: from per_assignments_f asg

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

Line 299: per_assignments_f paf

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

Line 314: per_assignments_f paf,

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

Line 332: per_assignments_f paf,

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

Line 423: per_assignments_f paf,

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

Line 446: per_assignments_f paf,

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

Line 497: per_assignments_f paf

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

Line 520: per_assignments_f paf,

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

Line 552: per_assignments_f paf

548: paa.serial_number,
549: paf.effective_end_date
550: from pay_payroll_actions ppa,
551: pay_assignment_actions paa,
552: per_assignments_f paf
553: where paf.person_id = to_char(cp_person_id)
554: and paf.assignment_id = paa.assignment_id
555: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
556: and ppa.business_group_id = ln_business_group_id

Line 569: from per_assignments_f paf

565: and nvl(pay_ca_archive_utils.get_archive_value(substr(paa.serial_number,3,14),
566: substr(paa.serial_number,1,2),'JURISDICTION_CODE',
567: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'
568: and paf.effective_end_date = (select max(paf.effective_end_date)
569: from per_assignments_f paf
570: where paf.assignment_id = paa.assignment_id
571: and paf.effective_start_date <= cp_effective_date
572: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
573: and not exists (select 1

Line 610: per_assignments_f paf

606: paa.serial_number,
607: paf.effective_end_date
608: from pay_payroll_actions ppa,
609: pay_assignment_actions paa,
610: per_assignments_f paf
611: where paf.person_id = to_char(cp_person_id)
612: and paf.assignment_id = paa.assignment_id
613: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
614: and ppa.business_group_id = ln_business_group_id

Line 621: from per_assignments_f paf

617: and ppa.payroll_action_id = paa.payroll_action_id
618: and ppa.effective_date = cp_effective_date
619: and ppa.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')
620: and paf.effective_end_date = (select max(paf.effective_end_date)
621: from per_assignments_f paf
622: where paf.assignment_id = paa.assignment_id
623: and paf.effective_start_date <= cp_effective_date
624: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
625: and exists

Line 665: per_assignments_f paf,

661: paa.serial_number,
662: paf.effective_end_date
663: from pay_payroll_actions ppa,
664: pay_assignment_actions paa,
665: per_assignments_f paf,
666: per_periods_of_service pds
667: where paf.person_id = to_char(cp_person_id)
668: and paf.assignment_id = paa.assignment_id
669: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 683: from per_assignments_f paf

679: and nvl(pay_ca_archive_utils.get_archive_value(substr(paa.serial_number,3,14),
680: substr(paa.serial_number,1,2),'JURISDICTION_CODE',
681: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'
682: and paf.effective_end_date = (select max(paf.effective_end_date)
683: from per_assignments_f paf
684: where paf.assignment_id = paa.assignment_id
685: and paf.effective_start_date <= cp_effective_date
686: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
687: and not exists (select 1

Line 726: per_assignments_f paf,

722: paa.serial_number,
723: paf.effective_end_date
724: from pay_payroll_actions ppa,
725: pay_assignment_actions paa,
726: per_assignments_f paf,
727: per_periods_of_service pds
728: where paf.person_id = to_char(cp_person_id)
729: and paf.assignment_id = paa.assignment_id
730: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 738: from per_assignments_f paf

734: and ppa.payroll_action_id = paa.payroll_action_id
735: and ppa.effective_date = cp_effective_date
736: and ppa.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')
737: and paf.effective_end_date = (select max(paf.effective_end_date)
738: from per_assignments_f paf
739: where paf.assignment_id = paa.assignment_id
740: and paf.effective_start_date <= cp_effective_date
741: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
742: and exists

Line 1381: l_per_id per_assignments_f.person_id%type;

1377:
1378: l_dt date;
1379: l_year number ;
1380: l_pre_id pay_assignment_actions.tax_unit_id%type;
1381: l_per_id per_assignments_f.person_id%type;
1382: l_sort1 varchar2(60);
1383: l_sort2 varchar2(60);
1384: l_sort3 varchar2(60);
1385: l_year_start date;