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

Line 294: from per_assignments_f asg

290: if ln_person_id is not null then
291:
292: lv_sql_string :=
293: 'select distinct asg.person_id person_id
294: from per_assignments_f asg
295: where person_id = ' || ln_person_id ||
296: ' and :payroll_action_id > 0';
297:
298: hr_utility.trace('Range for person_id not null');

Line 305: per_assignments_f paf

301:
302: lv_sql_string :=
303: 'select distinct paf.person_id
304: from hr_assignment_set_amendments asgset,
305: per_assignments_f paf
306: where assignment_set_id = ' || ln_asg_set || '
307: and asgset.assignment_id = paf.assignment_id
308: and asgset.include_or_exclude = ''I''
309: and :payroll_action_id > 0

Line 320: per_assignments_f paf,

316: lv_sql_string :=
317: 'select distinct paf.person_id
318: from pay_payroll_actions ppa_rep,
319: pay_assignment_actions paa_rep,
320: per_assignments_f paf,
321: pay_payroll_actions ppa
322: where paa_rep.assignment_id = paf.assignment_id
323: and ppa.payroll_action_id = :payroll_action_id
324: and ppa_rep.business_group_id = ppa.business_group_id

Line 339: per_assignments_f paf,

335: lv_sql_string :=
336: 'select distinct paf.person_id
337: from pay_payroll_actions ppa_rep,
338: pay_assignment_actions paa_rep,
339: per_assignments_f paf,
340: pay_payroll_actions ppa
341: where paa_rep.assignment_id = paf.assignment_id
342: and ppa.payroll_action_id = :payroll_action_id
343: and ppa_rep.business_group_id = ppa.business_group_id

Line 357: per_assignments_f paf,

353: lv_sql_string :=
354: 'select distinct paf.person_id
355: from pay_payroll_actions ppa_rep,
356: pay_assignment_actions paa_rep,
357: per_assignments_f paf,
358: pay_payroll_actions ppa
359: where paa_rep.assignment_id = paf.assignment_id
360: and ppa.payroll_action_id = :payroll_action_id
361: and ppa_rep.business_group_id = ppa.business_group_id

Line 375: per_assignments_f paf,

371: lv_sql_string :=
372: 'select distinct paf.person_id
373: from pay_payroll_actions ppa_rep,
374: pay_assignment_actions paa_rep,
375: per_assignments_f paf,
376: pay_payroll_actions ppa
377: where paa_rep.assignment_id = paf.assignment_id
378: and ppa.payroll_action_id = :payroll_action_id
379: and ppa_rep.business_group_id = ppa.business_group_id

Line 466: per_assignments_f paf,

462: ,cp_asg_set in number
463: ,cp_effective_date in date) is
464: select distinct paf.person_id
465: from hr_assignment_set_amendments asgset,
466: per_assignments_f paf,
467: pay_payroll_actions ppa,
468: pay_assignment_actions paa
469: where asgset.assignment_set_id = cp_asg_set
470: and asgset.include_or_exclude = 'I'

Line 490: per_assignments_f paf,

486: ,cp_asg_set in number
487: ,cp_effective_date in date) is
488: select distinct paf.person_id
489: from hr_assignment_set_amendments asgset,
490: per_assignments_f paf,
491: pay_payroll_actions ppa,
492: pay_assignment_actions paa,
493: pay_population_ranges ppr
494: where asgset.assignment_set_id = cp_asg_set

Line 541: per_assignments_f paf

537: cp_end_person number) is
538: select distinct paf.person_id
539: from pay_payroll_actions ppa_rep,
540: pay_assignment_actions paa_rep,
541: per_assignments_f paf
542: where ppa_rep.business_group_id = cp_bg_id
543: and ppa_rep.report_type in ('T4_XML','PAYCAT4AMPDF')
544: and ppa_rep.report_qualifier = 'DEFAULT'
545: and ppa_rep.effective_date = cp_eff_date

Line 565: per_assignments_f paf,

561: cp_end_person number) is
562: select distinct paf.person_id
563: from pay_payroll_actions ppa_rep,
564: pay_assignment_actions paa_rep,
565: per_assignments_f paf,
566: pay_population_ranges ppr
567: where ppa_rep.business_group_id = cp_bg_id
568: and ppa_rep.report_type in ('T4_XML','PAYCAT4AMPDF')
569: and ppa_rep.report_qualifier = 'DEFAULT'

Line 596: per_assignments_f paf

592: paa.serial_number,
593: paf.effective_end_date
594: from pay_payroll_actions ppa,
595: pay_assignment_actions paa,
596: per_assignments_f paf
597: where paf.person_id = to_char(cp_person_id)
598: and paf.assignment_id = paa.assignment_id
599: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
600: and ppa.business_group_id = ln_business_group_id

Line 610: from per_assignments_f paf

606: and decode(ppa.report_type,'T4_XML','LATEST','PAYCAT4AMPDF',
607: pay_ca_eoy_t4_cancel_pkg.get_parameter(
608: 'MODE',ppa.legislative_parameters)) = 'LATEST'
609: and paf.effective_end_date = (select max(paf.effective_end_date)
610: from per_assignments_f paf
611: where paf.assignment_id = paa.assignment_id
612: and paf.effective_start_date <= cp_effective_date
613: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
614: and not exists (select 1

Line 650: per_assignments_f paf

646: paa.serial_number,
647: paf.effective_end_date
648: from pay_payroll_actions ppa,
649: pay_assignment_actions paa,
650: per_assignments_f paf
651: where paf.person_id = to_char(cp_person_id)
652: and paf.assignment_id = paa.assignment_id
653: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
654: and ppa.business_group_id = ln_business_group_id

Line 661: from per_assignments_f paf

657: and ppa.payroll_action_id = paa.payroll_action_id
658: and ppa.effective_date = cp_effective_date
659: and ppa.report_type in ('T4_XML','PAYCAT4AMPDF')
660: and paf.effective_end_date = (select max(paf.effective_end_date)
661: from per_assignments_f paf
662: where paf.assignment_id = paa.assignment_id
663: and paf.effective_start_date <= cp_effective_date
664: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
665: and exists

Line 706: per_assignments_f paf,

702: paa.serial_number,
703: paf.effective_end_date
704: from pay_payroll_actions ppa,
705: pay_assignment_actions paa,
706: per_assignments_f paf,
707: per_periods_of_service PDS
708: where paf.person_id = to_char(cp_person_id)
709: and paf.assignment_id = paa.assignment_id
710: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 721: from per_assignments_f paf

717: and decode(ppa.report_type,'T4_XML','LATEST','PAYCAT4AMPDF',
718: pay_ca_eoy_t4_cancel_pkg.get_parameter(
719: 'MODE',ppa.legislative_parameters)) = 'LATEST'
720: and paf.effective_end_date = (select max(paf.effective_end_date)
721: from per_assignments_f paf
722: where paf.assignment_id = paa.assignment_id
723: and paf.effective_start_date <= cp_effective_date
724: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
725: and not exists (select 1

Line 763: per_assignments_f paf,

759: paa.serial_number,
760: paf.effective_end_date
761: from pay_payroll_actions ppa,
762: pay_assignment_actions paa,
763: per_assignments_f paf,
764: per_periods_of_service PDS
765: where paf.person_id = to_char(cp_person_id)
766: and paf.assignment_id = paa.assignment_id
767: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 775: from per_assignments_f paf

771: and ppa.payroll_action_id = paa.payroll_action_id
772: and ppa.effective_date = cp_effective_date
773: and ppa.report_type in ('T4_XML','PAYCAT4AMPDF')
774: and paf.effective_end_date = (select max(paf.effective_end_date)
775: from per_assignments_f paf
776: where paf.assignment_id = paa.assignment_id
777: and paf.effective_start_date <= cp_effective_date
778: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
779: and exists

Line 1406: l_per_id per_assignments_f.person_id%type;

1402:
1403: l_dt date;
1404: l_year number ;
1405: l_gre_id pay_assignment_actions.tax_unit_id%type;
1406: l_per_id per_assignments_f.person_id%type;
1407: l_sort1 varchar2(60);
1408: l_sort2 varchar2(60);
1409: l_sort3 varchar2(60);
1410: l_year_start date;