DBA Data[Home] [Help]

APPS.PAY_SA_RULES dependencies on PER_PERIODS_OF_SERVICE

Line 37: ,per_periods_of_service pos

33: into l_joiner
34: from pay_assignment_actions aa
35: ,pay_payroll_actions pa
36: ,per_all_assignments_f asg
37: ,per_periods_of_service pos
38: where aa.assignment_action_id = p_asg_act_id
39: and pa.payroll_action_id = aa.payroll_action_id
40: and aa.assignment_id = asg.assignment_id
41: and asg.period_of_service_id = pos.period_of_service_id

Line 70: ,per_periods_of_service POS

66: into l_leaver
67: from pay_assignment_actions aa
68: ,pay_payroll_actions pa
69: ,per_all_assignments_f asg
70: ,per_periods_of_service POS
71: where aa.assignment_action_id = p_asg_act_id
72: and pa.payroll_action_id = aa.payroll_action_id
73: and aa.assignment_id = asg.assignment_id
74: and asg.period_of_service_id = pos.period_of_service_id