DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PER_PERIODS_OF_SERVICE

Line 140: PER_PERIODS_OF_SERVICE b

136: a.business_group_id,
137: b.DATE_START,
138: b.ACTUAL_TERMINATION_DATE
139: from PER_ASSIGNMENTS_F a,
140: PER_PERIODS_OF_SERVICE b
141: where a.assignment_id = P_assignment_id
142: and P_calculation_date between a.effective_start_date and
143: a.effective_end_date
144: and a.PERIOD_OF_SERVICE_ID = b.PERIOD_OF_SERVICE_ID;