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

Line 279: from per_all_assignments_f a

275: cursor csr_assignment_status IS
276: select a.effective_start_date
277: , a.effective_end_date
278: , b.per_system_status
279: from per_all_assignments_f a
280: , per_assignment_status_types b
281: where a.assignment_id = P_Assignment_ID
282: and a.assignment_status_type_id = b.assignment_status_type_id
283: and P_Effective_Date

Line 891: from per_all_assignments_f

887: l_proc varchar2(72) := g_package||'Get_Payroll_ID';
888: --
889: cursor csr_get_payroll is
890: select payroll_id
891: from per_all_assignments_f
892: where assignment_id = P_asg_ID
893: and P_Date_In_Period between effective_start_date
894: and effective_end_date;
895: --

Line 1258: FROM per_all_assignments_f asg,

1254: l_proc varchar2(72) := g_package||'get_payroll_dtrange';
1255: --
1256: cursor csr_get_per_term_date is
1257: select max(actual_termination_date)
1258: FROM per_all_assignments_f asg,
1259: per_periods_of_service pps
1260: where asg.assignment_id = P_Assignment_id
1261: and asg.period_of_service_id = pps.period_of_service_id;
1262: --changes for bug 5749588 starts here

Line 1265: FROM per_all_assignments_f asg

1261: and asg.period_of_service_id = pps.period_of_service_id;
1262: --changes for bug 5749588 starts here
1263: cursor csr_get_Asg_term_date is
1264: select max(EFFECTIVE_END_DATE)
1265: FROM per_all_assignments_f asg
1266: where asg.assignment_id = P_Assignment_id
1267: and asg.assignment_type<>'B';
1268: --changes for bug 5749588 ends here
1269: