DBA Data[Home] [Help]

APPS.HR_PYOINT dependencies on PAY_ACTION_CLASSIFICATIONS

Line 75: pay_action_classifications pcl,

71: pa1.effective_date,
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

Line 95: pay_action_classifications pcl,

91: as1.assignment_number
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

Line 125: pay_action_classifications pcl,

121: from per_assignments_f as1,
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