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_T4AEOY_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 598: FROM per_all_assignments_f ASG,

594: SELECT ASG.person_id person_id,
595: ASG.assignment_id assignment_id,
596: paa.tax_unit_id tax_unit_id,
597: ASG.effective_end_date effective_end_date
598: FROM per_all_assignments_f ASG,
599: pay_assignment_actions paa,
600: pay_payroll_actions ppa
601: WHERE ppa.payroll_action_id >= 0
602: AND ppa.effective_date between l_period_start

Line 623: FROM per_all_assignments_f ASG,

619: SELECT ASG.person_id person_id,
620: ASG.assignment_id assignment_id,
621: paa.tax_unit_id tax_unit_id,
622: ASG.effective_end_date effective_end_date
623: FROM per_all_assignments_f ASG,
624: pay_assignment_actions paa,
625: pay_payroll_actions ppa,
626: per_all_people_f ppf
627: WHERE ppa.effective_date between l_period_start

Line 652: FROM per_all_assignments_f ASG,

648: SELECT ASG.person_id person_id,
649: ASG.assignment_id assignment_id,
650: paa.tax_unit_id tax_unit_id,
651: ASG.effective_end_date effective_end_date
652: FROM per_all_assignments_f ASG,
653: pay_assignment_actions paa,
654: pay_payroll_actions ppa,
655: per_all_people_f ppf,
656: pay_population_ranges ppr

Line 686: FROM per_all_assignments_f ASG,

682: SELECT ASG.person_id person_id,
683: ASG.assignment_id assignment_id,
684: to_number(SCL.segment11) tax_unit_id,
685: ASG.effective_end_date effective_end_date
686: FROM per_all_assignments_f ASG,
687: hr_soft_coding_keyflex SCL,
688: pay_all_payrolls_f PPY
689: WHERE ASG.business_group_id + 0 = l_bus_group_id
690: AND ASG.person_id between stperson and endperson

Line 702: from per_all_assignments_f paf

698: /* Get the primary assignment for the given person_id */
699:
700: CURSOR c_get_asg_id (p_person_id number) IS
701: SELECT assignment_id
702: from per_all_assignments_f paf
703: where person_id = p_person_id
704: and primary_flag = 'Y'
705: and assignment_type = 'E'
706: and paf.effective_start_date <= l_period_end

Line 885: per_all_assignments_f paf2,

881: begin
882: select paa1.assignment_action_id
883: into l_max_aaid
884: from pay_assignment_actions paa1,
885: per_all_assignments_f paf2,
886: pay_payroll_actions ppa2,
887: pay_action_classifications pac2
888: where paf2.person_id = l_person_id
889: and paa1.assignment_id = paf2.assignment_id

Line 902: per_all_assignments_f paf1

898: and not exists (select ''
899: FROM pay_action_classifications pac,
900: pay_payroll_actions ppa,
901: pay_assignment_actions paa,
902: per_all_assignments_f paf1
903: WHERE paf1.person_id = l_person_id
904: AND paa.assignment_id = paf1.assignment_id
905: AND paa.tax_unit_id = l_tax_unit_id
906: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2032: , per_all_assignments_f arch_paf

2028: , pay_assignment_actions run_paa
2029: , pay_payroll_actions run_ppa
2030: , pay_assignment_actions arch_paa
2031: , pay_payroll_actions arch_ppa
2032: , per_all_assignments_f arch_paf
2033: , per_all_assignments_f all_paf
2034: , hr_all_organization_units hou
2035: , hr_organization_information hoi
2036: where arch_paa.assignment_action_id = cp_asgact_id

Line 2033: , per_all_assignments_f all_paf

2029: , pay_payroll_actions run_ppa
2030: , pay_assignment_actions arch_paa
2031: , pay_payroll_actions arch_ppa
2032: , per_all_assignments_f arch_paf
2033: , per_all_assignments_f all_paf
2034: , hr_all_organization_units hou
2035: , hr_organization_information hoi
2036: where arch_paa.assignment_action_id = cp_asgact_id
2037: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id

Line 2094: per_all_assignments_f paf,

2090:
2091: CURSOR c_get_latest_asg(p_person_id number ) IS
2092: select paa.assignment_action_id
2093: from pay_assignment_actions paa,
2094: per_all_assignments_f paf,
2095: pay_payroll_actions ppa,
2096: pay_action_classifications pac
2097: where paf.person_id = p_person_id
2098: and paa.assignment_id = paf.assignment_id

Line 3445: , per_all_assignments_f arch_paf

3441: , pay_assignment_actions run_paa
3442: , pay_payroll_actions run_ppa
3443: , pay_assignment_actions arch_paa
3444: , pay_payroll_actions arch_ppa
3445: , per_all_assignments_f arch_paf
3446: , per_all_assignments_f all_paf
3447: , hr_all_organization_units hou
3448: , hr_organization_information hoi
3449: where arch_paa.assignment_action_id = cp_asgact_id

Line 3446: , per_all_assignments_f all_paf

3442: , pay_payroll_actions run_ppa
3443: , pay_assignment_actions arch_paa
3444: , pay_payroll_actions arch_ppa
3445: , per_all_assignments_f arch_paf
3446: , per_all_assignments_f all_paf
3447: , hr_all_organization_units hou
3448: , hr_organization_information hoi
3449: where arch_paa.assignment_action_id = cp_asgact_id
3450: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id

Line 3508: per_all_assignments_f paf,

3504:
3505: CURSOR c_get_latest_asg(p_person_id number ) IS
3506: select paa.assignment_action_id
3507: from pay_assignment_actions paa,
3508: per_all_assignments_f paf,
3509: pay_payroll_actions ppa,
3510: pay_action_classifications pac
3511: where paf.person_id = p_person_id
3512: and paa.assignment_id = paf.assignment_id

Line 3630: per_all_assignments_f paf2

3626: /*
3627: select paa1.assignment_action_id
3628: into l_aaid
3629: from pay_assignment_actions paa1,
3630: per_all_assignments_f paf2
3631: where paa1.assignment_id = paf2.assignment_id
3632: and paa1.tax_unit_id = l_tax_unit_id
3633: and (paa1.action_sequence , paf2.person_id) =
3634: (SELECT MAX(paa.action_sequence), paf.person_id

Line 3638: per_all_assignments_f paf1,

3634: (SELECT MAX(paa.action_sequence), paf.person_id
3635: FROM pay_action_classifications pac,
3636: pay_payroll_actions ppa,
3637: pay_assignment_actions paa,
3638: per_all_assignments_f paf1,
3639: per_all_assignments_f paf
3640: WHERE paf.assignment_id = l_asgid
3641: AND paf1.person_id = paf.person_id
3642: AND paa.tax_unit_id = l_tax_unit_id

Line 3639: per_all_assignments_f paf

3635: FROM pay_action_classifications pac,
3636: pay_payroll_actions ppa,
3637: pay_assignment_actions paa,
3638: per_all_assignments_f paf1,
3639: per_all_assignments_f paf
3640: WHERE paf.assignment_id = l_asgid
3641: AND paf1.person_id = paf.person_id
3642: AND paa.tax_unit_id = l_tax_unit_id
3643: AND paa.assignment_id = paf1.assignment_id

Line 5073: per_all_assignments_f ASSIGN

5069: l_middle_names, /* changed variable l_pre_name_adjunct to l_middle_names */
5070: l_organization_id,
5071: l_location_id
5072: from
5073: per_all_assignments_f ASSIGN
5074: , per_all_people_f PEOPLE
5075: , per_person_types PTYPE
5076: , fnd_sessions SES
5077: where l_date_earned BETWEEN ASSIGN.effective_start_date

Line 5494: per_all_assignments_f asg,

5490: distinct asg.person_id
5491: from pay_all_payrolls_f ppy,
5492: pay_payroll_actions ppa,
5493: pay_assignment_actions paa,
5494: per_all_assignments_f asg,
5495: pay_payroll_actions ppa1
5496: where ppa1.payroll_action_id = :payroll_action_id
5497: and ppa.effective_date between
5498: fnd_date.canonical_to_date('''||