DBA Data[Home] [Help]

APPS.PAY_KR_BAL_UPLOAD dependencies on PER_PERIODS_OF_SERVICE

Line 87: from per_periods_of_service ppos,

83: select nvl(add_months(ppos.date_start,
84: (floor(floor(months_between(p_upload_date,
85: ppos.date_start))/12)*12)),
86: g_eot)
87: from per_periods_of_service ppos,
88: per_assignments_f pa
89: where pa.assignment_id = p_assignment_id
90: and p_upload_date
91: between pa.effective_start_date and pa.effective_end_date