DBA Data[Home] [Help]

APPS.PAY_SG_BAL_UPLOAD dependencies on PER_TIME_PERIODS

Line 125: from per_time_periods PTP

121: p_assignment_id number
122: ,p_upload_date date
123: ) is
124: select nvl(PTP.start_date, END_OF_TIME)
125: from per_time_periods PTP
126: ,per_assignments_f ASS
127: where ASS.assignment_id = p_assignment_id
128: and p_upload_date between ASS.effective_start_date
129: and ASS.effective_end_date