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.

[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on PER_PERIODS_OF_SERVICE

Line 2156: per_periods_of_service.last_standard_process_date%TYPE;

2152: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2153: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2154: l_exists varchar2(1);
2155: l_last_standard_process_date
2156: per_periods_of_service.last_standard_process_date%TYPE;
2157: l_actual_termination_date
2158: per_periods_of_service.actual_termination_date%TYPE;
2159: l_legislation_code per_business_groups.legislation_code%TYPE;
2160: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 2158: per_periods_of_service.actual_termination_date%TYPE;

2154: l_exists varchar2(1);
2155: l_last_standard_process_date
2156: per_periods_of_service.last_standard_process_date%TYPE;
2157: l_actual_termination_date
2158: per_periods_of_service.actual_termination_date%TYPE;
2159: l_legislation_code per_business_groups.legislation_code%TYPE;
2160: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
2161: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2162: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

Line 3072: per_periods_of_service.last_standard_process_date%TYPE;

3068: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
3069: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
3070: l_exists varchar2(1);
3071: l_last_standard_process_date
3072: per_periods_of_service.last_standard_process_date%TYPE;
3073: l_actual_termination_date
3074: per_periods_of_service.actual_termination_date%TYPE;
3075: l_legislation_code per_business_groups.legislation_code%TYPE;
3076: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 3074: per_periods_of_service.actual_termination_date%TYPE;

3070: l_exists varchar2(1);
3071: l_last_standard_process_date
3072: per_periods_of_service.last_standard_process_date%TYPE;
3073: l_actual_termination_date
3074: per_periods_of_service.actual_termination_date%TYPE;
3075: l_legislation_code per_business_groups.legislation_code%TYPE;
3076: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
3077: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3078: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

Line 23287: ,per_periods_of_service pds

23283: ,MAX(mxa.effective_end_date) AS max_effective_end_date
23284: ,pds.actual_termination_date
23285: FROM per_all_assignments_f asg
23286: ,per_all_assignments_f mxa
23287: ,per_periods_of_service pds
23288: WHERE pds.period_of_service_id(+) = asg.period_of_service_id
23289: AND mxa.assignment_id = asg.assignment_id
23290: AND asg.assignment_id = csr_new_assignment.p_assignment_id
23291: AND csr_new_assignment.p_effective_date BETWEEN asg.effective_start_date