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 514: FROM per_all_assignments_f ASG,

510: SELECT ASG.person_id person_id,
511: ASG.assignment_id assignment_id,
512: paa.tax_unit_id tax_unit_id,
513: ASG.effective_end_date effective_end_date
514: FROM per_all_assignments_f ASG,
515: pay_assignment_actions paa,
516: pay_payroll_actions ppa
517: WHERE ppa.payroll_action_id >= 0
518: AND ppa.effective_date between l_period_start

Line 539: FROM per_all_assignments_f ASG,

535: SELECT ASG.person_id person_id,
536: ASG.assignment_id assignment_id,
537: paa.tax_unit_id tax_unit_id,
538: ASG.effective_end_date effective_end_date
539: FROM per_all_assignments_f ASG,
540: pay_assignment_actions paa,
541: pay_payroll_actions ppa,
542: per_all_people_f ppf
543: WHERE ppa.effective_date between l_period_start

Line 569: FROM per_all_assignments_f ASG,

565: SELECT ASG.person_id person_id,
566: ASG.assignment_id assignment_id,
567: to_number(SCL.segment11) tax_unit_id,
568: ASG.effective_end_date effective_end_date
569: FROM per_all_assignments_f ASG,
570: hr_soft_coding_keyflex SCL,
571: pay_all_payrolls_f PPY
572: WHERE ASG.business_group_id + 0 = l_bus_group_id
573: AND ASG.person_id between stperson and endperson

Line 585: from per_all_assignments_f paf

581: /* Get the primary assignment for the given person_id */
582:
583: CURSOR c_get_asg_id (p_person_id number) IS
584: SELECT assignment_id
585: from per_all_assignments_f paf
586: where person_id = p_person_id
587: and primary_flag = 'Y'
588: and assignment_type = 'E'
589: and paf.effective_start_date <= l_period_end

Line 716: per_all_assignments_f paf2,

712: begin
713: select paa1.assignment_action_id
714: into l_max_aaid
715: from pay_assignment_actions paa1,
716: per_all_assignments_f paf2,
717: pay_payroll_actions ppa2,
718: pay_action_classifications pac2
719: where paf2.person_id = l_person_id
720: and paa1.assignment_id = paf2.assignment_id

Line 733: per_all_assignments_f paf1

729: and not exists (select ''
730: FROM pay_action_classifications pac,
731: pay_payroll_actions ppa,
732: pay_assignment_actions paa,
733: per_all_assignments_f paf1
734: WHERE paf1.person_id = l_person_id
735: AND paa.assignment_id = paf1.assignment_id
736: AND paa.tax_unit_id = l_tax_unit_id
737: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1901: , per_all_assignments_f arch_paf

1897: , pay_assignment_actions run_paa
1898: , pay_payroll_actions run_ppa
1899: , pay_assignment_actions arch_paa
1900: , pay_payroll_actions arch_ppa
1901: , per_all_assignments_f arch_paf
1902: , per_all_assignments_f all_paf
1903: , hr_all_organization_units hou
1904: , hr_organization_information hoi
1905: where arch_paa.assignment_action_id = cp_asgact_id

Line 1902: , per_all_assignments_f all_paf

1898: , pay_payroll_actions run_ppa
1899: , pay_assignment_actions arch_paa
1900: , pay_payroll_actions arch_ppa
1901: , per_all_assignments_f arch_paf
1902: , per_all_assignments_f all_paf
1903: , hr_all_organization_units hou
1904: , hr_organization_information hoi
1905: where arch_paa.assignment_action_id = cp_asgact_id
1906: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id

Line 1963: per_all_assignments_f paf,

1959:
1960: CURSOR c_get_latest_asg(p_person_id number ) IS
1961: select paa.assignment_action_id
1962: from pay_assignment_actions paa,
1963: per_all_assignments_f paf,
1964: pay_payroll_actions ppa,
1965: pay_action_classifications pac
1966: where paf.person_id = p_person_id
1967: and paa.assignment_id = paf.assignment_id

Line 2085: per_all_assignments_f paf2

2081: /*
2082: select paa1.assignment_action_id
2083: into l_aaid
2084: from pay_assignment_actions paa1,
2085: per_all_assignments_f paf2
2086: where paa1.assignment_id = paf2.assignment_id
2087: and paa1.tax_unit_id = l_tax_unit_id
2088: and (paa1.action_sequence , paf2.person_id) =
2089: (SELECT MAX(paa.action_sequence), paf.person_id

Line 2093: per_all_assignments_f paf1,

2089: (SELECT MAX(paa.action_sequence), paf.person_id
2090: FROM pay_action_classifications pac,
2091: pay_payroll_actions ppa,
2092: pay_assignment_actions paa,
2093: per_all_assignments_f paf1,
2094: per_all_assignments_f paf
2095: WHERE paf.assignment_id = l_asgid
2096: AND paf1.person_id = paf.person_id
2097: AND paa.tax_unit_id = l_tax_unit_id

Line 2094: per_all_assignments_f paf

2090: FROM pay_action_classifications pac,
2091: pay_payroll_actions ppa,
2092: pay_assignment_actions paa,
2093: per_all_assignments_f paf1,
2094: per_all_assignments_f paf
2095: WHERE paf.assignment_id = l_asgid
2096: AND paf1.person_id = paf.person_id
2097: AND paa.tax_unit_id = l_tax_unit_id
2098: AND paa.assignment_id = paf1.assignment_id

Line 3460: per_all_assignments_f ASSIGN

3456: l_middle_names, /* changed variable l_pre_name_adjunct to l_middle_names */
3457: l_organization_id,
3458: l_location_id
3459: from
3460: per_all_assignments_f ASSIGN
3461: , per_all_people_f PEOPLE
3462: , per_person_types PTYPE
3463: , fnd_sessions SES
3464: where l_date_earned BETWEEN ASSIGN.effective_start_date

Line 3795: per_all_assignments_f asg,

3791: distinct asg.person_id
3792: from pay_all_payrolls_f ppy,
3793: pay_payroll_actions ppa,
3794: pay_assignment_actions paa,
3795: per_all_assignments_f asg,
3796: pay_payroll_actions ppa1
3797: where ppa1.payroll_action_id = :payroll_action_id
3798: and ppa.effective_date between
3799: fnd_date.canonical_to_date('''||