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 375: from per_all_assignments_f a

371: cursor csr_assignment_status IS
372: select a.effective_start_date
373: , a.effective_end_date
374: , b.per_system_status
375: from per_all_assignments_f a
376: , per_assignment_status_types b
377: where a.assignment_id = P_Assignment_ID
378: and a.assignment_status_type_id = b.assignment_status_type_id
379: and P_Effective_Date

Line 987: from per_all_assignments_f

983: l_proc varchar2(72) := g_package||'Get_Payroll_ID';
984: --
985: cursor csr_get_payroll is
986: select payroll_id
987: from per_all_assignments_f
988: where assignment_id = P_asg_ID
989: and P_Date_In_Period between effective_start_date
990: and effective_end_date;
991: --

Line 1354: FROM per_all_assignments_f asg,

1350: l_proc varchar2(72) := g_package||'get_payroll_dtrange';
1351: --
1352: cursor csr_get_per_term_date is
1353: select max(actual_termination_date)
1354: FROM per_all_assignments_f asg,
1355: per_periods_of_service pps
1356: where asg.assignment_id = P_Assignment_id
1357: and asg.period_of_service_id = pps.period_of_service_id;
1358: --changes for bug 5749588 starts here

Line 1361: FROM per_all_assignments_f asg

1357: and asg.period_of_service_id = pps.period_of_service_id;
1358: --changes for bug 5749588 starts here
1359: cursor csr_get_Asg_term_date is
1360: select max(EFFECTIVE_END_DATE)
1361: FROM per_all_assignments_f asg
1362: where asg.assignment_id = P_Assignment_id
1363: and asg.assignment_type<>'B';
1364: --changes for bug 5749588 ends here
1365: