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

Line 42: joins to per_assignments_f

38: report is Register or Paper.
39: 01-SEP-2004 SSouresr 115.4 Made changes to the package to
40: support multi assignments
41: and also removed unnecessary
42: joins to per_assignments_f
43: 27-SEP-2004 SSouresr 115.5 Corrected action_creation for
44: scenario with assignment set but
45: no GRE
46: 22-NOV-2004 SSouresr 115.6 Replaced tables with views and also

Line 346: from per_assignments_f asg

342: if ln_person_id is not null then
343:
344: lv_sql_string :=
345: 'select distinct asg.person_id person_id
346: from per_assignments_f asg
347: where person_id = ' || ln_person_id ||
348: ' and :payroll_action_id > 0';
349:
350: hr_utility.trace('Range for person_id not null');

Line 357: per_assignments_f paf

353:
354: lv_sql_string :=
355: 'select distinct paf.person_id
356: from hr_assignment_set_amendments asgset,
357: per_assignments_f paf
358: where assignment_set_id = ' || ln_asg_set || '
359: and asgset.assignment_id = paf.assignment_id
360: and asgset.include_or_exclude = ''I''
361: and :payroll_action_id > 0

Line 372: per_assignments_f paf,

368: lv_sql_string :=
369: 'select distinct paf.person_id
370: from pay_payroll_actions ppa_arch,
371: pay_assignment_actions paa_arch,
372: per_assignments_f paf,
373: pay_payroll_actions ppa
374: where paa_arch.assignment_id = paf.assignment_id
375: and ppa.payroll_action_id = :payroll_action_id
376: and ppa_arch.business_group_id = ppa.business_group_id

Line 390: per_assignments_f paf,

386: lv_sql_string :=
387: 'select distinct paf.person_id
388: from pay_payroll_actions ppa_arch,
389: pay_assignment_actions paa_arch,
390: per_assignments_f paf,
391: pay_payroll_actions ppa
392: where paa_arch.assignment_id = paf.assignment_id
393: and ppa.payroll_action_id = :payroll_action_id
394: and ppa_arch.business_group_id = ppa.business_group_id

Line 481: per_assignments_f paf,

477: ,cp_asg_set in number
478: ,cp_effective_date in date) is
479: select distinct paf.person_id
480: from hr_assignment_set_amendments asgset,
481: per_assignments_f paf,
482: pay_payroll_actions ppa,
483: pay_assignment_actions paa
484: where asgset.assignment_set_id = cp_asg_set
485: and asgset.include_or_exclude = 'I'

Line 505: per_assignments_f paf,

501: ,cp_asg_set in number
502: ,cp_effective_date in date) is
503: select distinct paf.person_id
504: from hr_assignment_set_amendments asgset,
505: per_assignments_f paf,
506: pay_payroll_actions ppa,
507: pay_assignment_actions paa,
508: pay_population_ranges ppr
509: where asgset.assignment_set_id = cp_asg_set

Line 624: from per_assignments_f paf

620: and pai.locking_action_id = paa1.assignment_action_id
621: and paa1.payroll_action_id = ppa1.payroll_action_id
622: and ppa1.report_type = ppa.report_type)
623: and exists (select 1
624: from per_assignments_f paf
625: where paf.assignment_id = paa.assignment_id
626: and paf.effective_start_date <= cp_effective_date
627: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
628: order by paa.assignment_action_id desc;

Line 641: per_assignments_f paf

637: paa.tax_unit_id,
638: paf.effective_end_date
639: from pay_payroll_actions ppa,
640: pay_assignment_actions paa,
641: per_assignments_f paf
642: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
643: and paa.assignment_id = paf.assignment_id
644: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
645: and ppa.business_group_id = ln_business_group_id

Line 664: from per_assignments_f paf

660: AND passt.tax_unit_id = paa.tax_unit_id
661: AND (pail.locked_action_id = paa.assignment_action_id
662: OR paa.assignment_action_id < passt.assignment_action_id))
663: and paf.effective_end_date = (select max(paf.effective_end_date)
664: from per_assignments_f paf
665: where paf.assignment_id = paa.assignment_id
666: and paf.effective_start_date <= cp_effective_date
667: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
668: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,paa.tax_unit_id,paf.effective_end_date

Line 688: from per_assignments_f paf

684: and ppa.payroll_action_id = paa.payroll_action_id
685: and ppa.effective_date = cp_effective_date
686: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
687: and exists (select 1
688: from per_assignments_f paf
689: where paf.assignment_id = paa.assignment_id
690: and paf.effective_start_date <= cp_effective_date
691: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
692: order by paa.assignment_action_id desc;

Line 705: per_assignments_f paf

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

Line 739: from per_assignments_f paf

735: AND ppa2.effective_date = cp_effective_date /*Added for 10381064*/
736: AND paa2.assignment_id=paa.assignment_id
737: )
738: and paf.effective_end_date = (select max(paf.effective_end_date)
739: from per_assignments_f paf
740: where paf.assignment_id = paa.assignment_id
741: and paf.effective_start_date <= cp_effective_date
742: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
743: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,paa.tax_unit_id,paf.effective_end_date

Line 758: per_assignments_f paf,

754: paa.tax_unit_id,
755: paf.effective_end_date
756: from pay_payroll_actions ppa,
757: pay_assignment_actions paa,
758: per_assignments_f paf,
759: per_periods_of_service PDS
760: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
761: and paa.assignment_id = paf.assignment_id
762: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 782: from per_assignments_f paf

778: AND passt.tax_unit_id = paa.tax_unit_id
779: AND (pail.locked_action_id = paa.assignment_action_id
780: OR paa.assignment_action_id < passt.assignment_action_id))
781: and paf.effective_end_date = (select max(paf.effective_end_date)
782: from per_assignments_f paf
783: where paf.assignment_id = paa.assignment_id
784: and paf.effective_start_date <= cp_effective_date
785: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
786: and pds.actual_termination_date is not null

Line 802: per_assignments_f paf,

798: paa.tax_unit_id,
799: paf.effective_end_date
800: from pay_payroll_actions ppa,
801: pay_assignment_actions paa,
802: per_assignments_f paf,
803: per_periods_of_service PDS
804: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
805: and paa.assignment_id = paf.assignment_id
806: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 837: from per_assignments_f paf

833: AND ppa2.effective_date = cp_effective_date /*Added for 10381064*/
834: AND paa2.assignment_id=paa.assignment_id
835: )
836: and paf.effective_end_date = (select max(paf.effective_end_date)
837: from per_assignments_f paf
838: where paf.assignment_id = paa.assignment_id
839: and paf.effective_start_date <= cp_effective_date
840: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
841: and pds.actual_termination_date is not null

Line 1758: l_per_id per_assignments_f.person_id%type;

1754:
1755: l_dt date;
1756: l_year number ;
1757: l_gre_id pay_assignment_actions.tax_unit_id%type;
1758: l_per_id per_assignments_f.person_id%type;
1759: l_sort1 varchar2(60);
1760: l_sort2 varchar2(60);
1761: l_sort3 varchar2(60);
1762: l_year_start date;