DBA Data[Home] [Help]

APPS.PAY_SA_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 36: ,per_all_assignments_f asg

32: select 'Y'
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

Line 69: ,per_all_assignments_f asg

65: select 'Y'
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

Line 101: ,per_all_assignments_f asg

97: select nationality
98: into l_nationality_cd
99: from pay_assignment_actions aa
100: ,pay_payroll_actions pa
101: ,per_all_assignments_f asg
102: ,per_all_people_f per
103: where aa.assignment_action_id = p_asg_act_id
104: and pa.payroll_action_id = aa.payroll_action_id
105: and aa.assignment_id = asg.assignment_id