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

Line 317: from per_assignments_f asg

313: if ln_person_id is not null then
314:
315: lv_sql_string :=
316: 'select distinct asg.person_id person_id
317: from per_assignments_f asg
318: where person_id = ' || ln_person_id ||
319: ' and :p_payroll_action_id > 0';
320:
321: hr_utility.trace('Range for person_id not null');

Line 328: per_assignments_f paf

324:
325: lv_sql_string :=
326: 'select distinct paf.person_id
327: from hr_assignment_set_amendments asgset,
328: per_assignments_f paf
329: where assignment_set_id = ' || ln_asg_set || '
330: and asgset.assignment_id = paf.assignment_id
331: and asgset.include_or_exclude = ''I''
332: and :p_payroll_action_id > 0

Line 343: per_assignments_f paf,

339: lv_sql_string :=
340: 'select distinct paf.person_id
341: from pay_payroll_actions ppa_arch,
342: pay_assignment_actions paa_arch,
343: per_assignments_f paf,
344: pay_payroll_actions ppa
345: where paa_arch.assignment_id = paf.assignment_id
346: and ppa.payroll_action_id = :p_payroll_action_id
347: and ppa_arch.business_group_id = ppa.business_group_id

Line 361: per_assignments_f paf,

357: lv_sql_string :=
358: 'select distinct paf.person_id
359: from pay_payroll_actions ppa_arch,
360: pay_assignment_actions paa_arch,
361: per_assignments_f paf,
362: pay_payroll_actions ppa
363: where paa_arch.assignment_id = paf.assignment_id
364: and ppa.payroll_action_id = :p_payroll_action_id
365: and ppa_arch.business_group_id = ppa.business_group_id

Line 443: per_assignments_f paf,

439: ,cp_asg_set in number
440: ,cp_effective_date in date) is
441: select distinct paf.person_id
442: from hr_assignment_set_amendments asgset,
443: per_assignments_f paf,
444: pay_payroll_actions ppa,
445: pay_assignment_actions paa
446: where asgset.assignment_set_id = cp_asg_set
447: and asgset.include_or_exclude = 'I'

Line 468: per_assignments_f paf,

464: ,cp_asg_set in number
465: ,cp_effective_date in date) is
466: select distinct paf.person_id
467: from hr_assignment_set_amendments asgset,
468: per_assignments_f paf,
469: pay_payroll_actions ppa,
470: pay_assignment_actions paa,
471: pay_population_ranges ppr
472: where asgset.assignment_set_id = cp_asg_set

Line 587: from per_assignments_f paf

583: and pai.locking_action_id = paa1.assignment_action_id
584: and paa1.payroll_action_id = ppa1.payroll_action_id
585: and ppa1.report_type = ppa.report_type)
586: and exists (select 1
587: from per_assignments_f paf
588: where paf.assignment_id = paa.assignment_id
589: and paf.effective_start_date <= cp_effective_date
590: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
591: order by paa.assignment_action_id desc;

Line 603: per_assignments_f paf

599: paa.tax_unit_id,
600: paf.effective_end_date
601: from pay_payroll_actions ppa,
602: pay_assignment_actions paa,
603: per_assignments_f paf
604: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
605: and paa.assignment_id = paf.assignment_id
606: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
607: and ppa.business_group_id = ln_business_group_id

Line 626: from per_assignments_f paf

622: AND passt.tax_unit_id = paa.tax_unit_id -- Added this condition #10332249
623: AND (pail.locked_action_id = paa.assignment_action_id
624: OR paa.assignment_action_id < passt.assignment_action_id))
625: and paf.effective_end_date = (select max(paf.effective_end_date)
626: from per_assignments_f paf
627: where paf.assignment_id = paa.assignment_id
628: and paf.effective_start_date <= cp_effective_date
629: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
630: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,paa.tax_unit_id,paf.effective_end_date

Line 650: from per_assignments_f paf

646: and ppa.payroll_action_id = paa.payroll_action_id
647: and ppa.effective_date = cp_effective_date
648: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
649: and exists (select 1
650: from per_assignments_f paf
651: where paf.assignment_id = paa.assignment_id
652: and paf.effective_start_date <= cp_effective_date
653: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
654: order by paa.assignment_action_id desc;

Line 666: per_assignments_f paf

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

Line 689: from per_assignments_f paf

685: AND passt.tax_unit_id = paa.tax_unit_id --#10352779
686: AND (pail.locked_action_id = paa.assignment_action_id
687: OR paa.assignment_action_id < passt.assignment_action_id))
688: and paf.effective_end_date = (select max(paf.effective_end_date)
689: from per_assignments_f paf
690: where paf.assignment_id = paa.assignment_id
691: and paf.effective_start_date <= cp_effective_date
692: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
693: /* Added not exists condition for # 10323048 */

Line 718: per_assignments_f paf,

714: paa.tax_unit_id,
715: paf.effective_end_date
716: from pay_payroll_actions ppa,
717: pay_assignment_actions paa,
718: per_assignments_f paf,
719: per_periods_of_service pds
720: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
721: and paa.assignment_id = paf.assignment_id
722: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 742: from per_assignments_f paf

738: AND passt.tax_unit_id = paa.tax_unit_id -- Added this condition #10332249
739: AND (pail.locked_action_id = paa.assignment_action_id
740: OR paa.assignment_action_id < passt.assignment_action_id))
741: and paf.effective_end_date = (select max(paf.effective_end_date)
742: from per_assignments_f paf
743: where paf.assignment_id = paa.assignment_id
744: and paf.effective_start_date <= cp_effective_date
745: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
746: and pds.actual_termination_date is not null

Line 761: per_assignments_f paf,

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

Line 785: from per_assignments_f paf

781: AND passt.tax_unit_id = paa.tax_unit_id --#10352779
782: AND (pail.locked_action_id = paa.assignment_action_id
783: OR paa.assignment_action_id < passt.assignment_action_id))
784: and paf.effective_end_date = (select max(paf.effective_end_date)
785: from per_assignments_f paf
786: where paf.assignment_id = paa.assignment_id
787: and paf.effective_start_date <= cp_effective_date
788: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
789: /* Added not exists condition for # 10323048 */