APPS.PEPTOEXC dependencies on PER_ALL_ASSIGNMENTS_F

Line 183: per_all_assignments_f asg,

179: pps.date_start
180: )/12) *12) finyear
181: into l_accrual_year_end
182: from per_periods_of_service pps,
183: per_all_assignments_f asg,
184: pay_payroll_actions bact,
185: pay_assignment_actions bal_assact
186: where bact.payroll_action_id = p_owner_payroll_action_id
187: and bal_assact.payroll_action_id = bact.payroll_action_id

Line 230: per_all_assignments_f asg,

226: pps.date_start
227: )/12) *12) finyear
228: into l_accrual_year_end
229: from per_periods_of_service pps,
230: per_all_assignments_f asg,
231: pay_payroll_actions bact,
232: pay_assignment_actions bal_assact
233: where bact.payroll_action_id = p_owner_payroll_action_id
234: and bal_assact.payroll_action_id = bact.payroll_action_id

Line 527: per_all_assignments_f asg,

523: pps.date_start
524: )/12) *12) finyear
525: into l_expiry_date
526: from per_periods_of_service pps,
527: per_all_assignments_f asg,
528: pay_payroll_actions bact,
529: pay_assignment_actions bal_assact
530: where bact.payroll_action_id = p_owner_payroll_action_id
531: and bal_assact.payroll_action_id = bact.payroll_action_id

Line 593: per_all_assignments_f asg,

589: pps.date_start
590: )/12) *12) finyear
591: into l_expiry_date
592: from per_periods_of_service pps,
593: per_all_assignments_f asg,
594: pay_payroll_actions bact,
595: pay_assignment_actions bal_assact
596: where bact.payroll_action_id = p_owner_payroll_action_id
597: and bal_assact.payroll_action_id = bact.payroll_action_id