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.HR_ASSIGNMENT_API dependencies on PER_PERIODS_OF_SERVICE

Line 1595: per_periods_of_service.last_standard_process_date%TYPE;

1591: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1592: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
1593: l_exists varchar2(1);
1594: l_last_standard_process_date
1595: per_periods_of_service.last_standard_process_date%TYPE;
1596: l_actual_termination_date
1597: per_periods_of_service.actual_termination_date%TYPE;
1598: l_legislation_code per_business_groups.legislation_code%TYPE;
1599: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 1597: per_periods_of_service.actual_termination_date%TYPE;

1593: l_exists varchar2(1);
1594: l_last_standard_process_date
1595: per_periods_of_service.last_standard_process_date%TYPE;
1596: l_actual_termination_date
1597: per_periods_of_service.actual_termination_date%TYPE;
1598: l_legislation_code per_business_groups.legislation_code%TYPE;
1599: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1600: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1601: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

Line 2505: per_periods_of_service.last_standard_process_date%TYPE;

2501: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2502: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2503: l_exists varchar2(1);
2504: l_last_standard_process_date
2505: per_periods_of_service.last_standard_process_date%TYPE;
2506: l_actual_termination_date
2507: per_periods_of_service.actual_termination_date%TYPE;
2508: l_legislation_code per_business_groups.legislation_code%TYPE;
2509: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 2507: per_periods_of_service.actual_termination_date%TYPE;

2503: l_exists varchar2(1);
2504: l_last_standard_process_date
2505: per_periods_of_service.last_standard_process_date%TYPE;
2506: l_actual_termination_date
2507: per_periods_of_service.actual_termination_date%TYPE;
2508: l_legislation_code per_business_groups.legislation_code%TYPE;
2509: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
2510: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2511: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

Line 22239: ,per_periods_of_service pds

22235: ,MAX(mxa.effective_end_date) AS max_effective_end_date
22236: ,pds.actual_termination_date
22237: FROM per_all_assignments_f asg
22238: ,per_all_assignments_f mxa
22239: ,per_periods_of_service pds
22240: WHERE pds.period_of_service_id(+) = asg.period_of_service_id
22241: AND mxa.assignment_id = asg.assignment_id
22242: AND asg.assignment_id = csr_new_assignment.p_assignment_id
22243: AND csr_new_assignment.p_effective_date BETWEEN asg.effective_start_date