APPS.PAY_HK_BAL_UPLOAD dependencies on PER_TIME_PERIODS
Line 129: from per_time_periods PTP
125: p_assignment_id number
126: ,p_upload_date date
127: ) is
128: select nvl(PTP.start_date, END_OF_TIME) 129: from per_time_periods PTP 130: ,per_assignments_f ASS
131: where ASS.assignment_id = p_assignment_id
132: and p_upload_date between ASS.effective_start_date
133: and ASS.effective_end_date