APPS.PAY_YEAR_END_EXTRACT dependencies on PER_PERIODS_OF_SERVICE

Line 1142: from per_periods_of_service pos,

1138: hr_utility.trace( 'set termination date' );
1139: update pay_gb_year_end_assignments ye_asg
1140: set ( termination_date, termination_type ) =
1141: (select actual_termination_date ,'L'
1142: from per_periods_of_service pos,
1143: per_assignments_f asg,
1144: pay_gb_year_end_payrolls ye_roll
1145: where pos.person_id = ye_asg.person_id
1146: and ye_asg.assignment_id = asg.assignment_id

Line 1158: from per_periods_of_service pos,

1154: nvl(ye_roll.start_previous_year,ye_roll.start_year))
1155: and least(ye_asg.effective_end_date,ye_roll.end_year))
1156: where ye_asg.request_id = p_request_id
1157: and exists ( select 1
1158: from per_periods_of_service pos,
1159: per_assignments_f asg,
1160: pay_gb_year_end_payrolls ye_roll
1161: where pos.person_id = ye_asg.person_id
1162: and ye_asg.assignment_id = asg.assignment_id

Line 1181: from per_periods_of_service pos,

1177: --
1178: update pay_gb_year_end_assignments ye_asg
1179: set (start_of_emp) =
1180: (select pos.date_start
1181: from per_periods_of_service pos,
1182: per_assignments_f asg,
1183: pay_gb_year_end_payrolls ye_roll
1184: where pos.person_id = ye_asg.person_id
1185: and ye_asg.assignment_id = asg.assignment_id

Line 1192: from per_periods_of_service pos,

1188: and ye_asg.payroll_id = ye_roll.payroll_id
1189: and pos.date_start between l_start_year and l_end_year)
1190: where ye_asg.request_id = p_request_id
1191: and exists ( select 1
1192: from per_periods_of_service pos,
1193: per_assignments_f asg,
1194: pay_gb_year_end_payrolls ye_roll
1195: where pos.person_id = ye_asg.person_id
1196: and ye_asg.assignment_id = asg.assignment_id