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.PER_FR_D2_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 540: from per_all_assignments_f

536: cursor csr_last_job
537: is
538: -- select last job in the year for an employee
539: select job_id
540: from per_all_assignments_f
541: where person_id = p_person_id
542: and nvl(establishment_id,-1) = p_establishment_id
543: and effective_start_date <= p_31dec
544: and effective_end_date >= p_1jan

Line 1114: per_all_assignments_f a

1110: --
1111: select nvl(least(p_end_period,max(a.effective_end_date)),to_date('31124712','DDMMYYYY'))
1112: into l_end_date
1113: from per_assignment_status_types t,
1114: per_all_assignments_f a
1115: where a.assignment_id = p_assignment_id
1116: and a.establishment_id = p_establishment_id
1117: and a.effective_start_date <= p_end_period
1118: and a.effective_end_date >= p_start_period

Line 1168: from per_all_assignments_f a,

1164: l_start_per,
1165: l_start_ctr,
1166: l_start_ptu,
1167: l_start_bud
1168: from per_all_assignments_f a,
1169: per_all_people_f p,
1170: per_contracts_f c,
1171: per_person_type_usages_f ptu,
1172: per_assignment_budget_values_f b

Line 1280: per_all_assignments_f asg

1276: per_all_positions pos,
1277: hr_organization_information org,
1278: hr_organization_information bus,
1279: per_assignment_budget_values_f bud,
1280: per_all_assignments_f asg
1281: where asg.assignment_id = p_assignment_id
1282: and p_start_date between asg.effective_start_date
1283: and asg.effective_end_date
1284: and per.person_id = asg.person_id