DBA Data[Home] [Help]

APPS.PEPTOEXC dependencies on PAY_ASSIGNMENT_ACTIONS

Line 185: pay_assignment_actions bal_assact

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
188: and pps.period_of_service_id = asg.period_of_service_id
189: and asg.assignment_id = bal_assact.assignment_id

Line 232: pay_assignment_actions bal_assact

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
235: and pps.period_of_service_id = asg.period_of_service_id
236: and asg.assignment_id = bal_assact.assignment_id

Line 529: pay_assignment_actions bal_assact

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
532: and pps.period_of_service_id = asg.period_of_service_id
533: and asg.assignment_id = bal_assact.assignment_id

Line 595: pay_assignment_actions bal_assact

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
598: and pps.period_of_service_id = asg.period_of_service_id
599: and asg.assignment_id = bal_assact.assignment_id