DBA Data[Home] [Help]

APPS.HR_PYOINT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 76: pay_assignment_actions ac2

72: pa2.effective_date
73: from pay_payroll_actions pa1,
74: pay_payroll_actions pa2,
75: pay_action_classifications pcl,
76: pay_assignment_actions ac2
77: where pa1.payroll_action_id = pactid
78: and ac2.assignment_id = assignid
79: and pa2.payroll_action_id = ac2.payroll_action_id
80: and pcl.classification_name = 'SEQUENCED'

Line 96: pay_assignment_actions ac2,

92: from per_assignments_f as1,
93: pay_payroll_actions pa1,
94: pay_payroll_actions pa2,
95: pay_action_classifications pcl,
96: pay_assignment_actions ac2,
97: pay_object_groups pog_act,
98: pay_object_groups pog_grp
99: where pa1.payroll_action_id = pactid
100: and as1.assignment_id = assignid

Line 126: pay_assignment_actions ac2,

122: per_assignments_f as2,
123: pay_payroll_actions pa1,
124: pay_payroll_actions pa2,
125: pay_action_classifications pcl,
126: pay_assignment_actions ac2,
127: per_periods_of_service pos
128: where pa1.payroll_action_id = pactid
129: and as1.assignment_id = assignid
130: and pa1.effective_date between