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

Line 908: from per_assignments_f paf2

904: AND asgn2.assignment_id = paa.assignment_id
905: AND per.person_id = asgn2.person_id
906: AND asgn2.effective_start_date =
907: ( select max(paf2.effective_start_date)
908: from per_assignments_f paf2
909: where paf2.effective_start_date <= ppa.effective_date
910: and paf2.assignment_id = asgn2.assignment_id
911: )
912: AND per.effective_start_date =

Line 3242: per_assignments_f ass,

3238: (select haou.location_id
3239: from hr_all_organization_units haou
3240: where haou.organization_id=ass.organization_id) org_location_id
3241: from
3242: per_assignments_f ass,
3243: per_all_people_f per,
3244: per_assignment_extra_info aei
3245: where
3246: ass.payroll_id = nvl(:1,ass.payroll_id)

Line 3273: from per_assignments_f ass1

3269: and (:10 between ass.effective_start_date and ass.effective_end_date
3270: OR
3271: (ass.effective_end_date <=:11
3272: and ass.effective_end_date = ( select max(ass1.effective_end_date)
3273: from per_assignments_f ass1
3274: where ass.assignment_id = ass1.assignment_id
3275: )))
3276: and per.person_id = ass.person_id
3277: and :12 between per.effective_start_date and per.effective_end_date

Line 3947: from per_assignments_f paf2

3943: AND asgn2.assignment_id = paa.assignment_id
3944: AND per.person_id = asgn2.person_id
3945: AND asgn2.effective_start_date =
3946: ( select max(paf2.effective_start_date)
3947: from per_assignments_f paf2
3948: where paf2.effective_start_date <= ( select max(ptp.end_date)
3949: from per_time_periods ptp
3950: where ptp.prd_information1 = p_tax_year
3951: and ptp.payroll_id = asgn2.payroll_id)