DBA Data[Home] [Help]

APPS.PAY_ACTION_CONTEXTS_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 95: PER_PERIODS_OF_SERVICE pos

91: SELECT DISTINCT
92: asg.assignment_id
93: FROM PAY_PAYROLL_ACTIONS pa,
94: PER_ALL_ASSIGNMENTS_F asg,
95: PER_PERIODS_OF_SERVICE pos
96: WHERE pa.payroll_action_id = b_pay_act_id
97: and asg.business_group_id = pa.business_group_id
98: and pa.effective_date between
99: asg.effective_start_date and asg.effective_end_date