APPS.PAY_KW_BAL_UPLOAD dependencies on PER_TIME_PERIODS
Line 64: from per_time_periods PTP
60: p_assignment_id number
61: ,p_upload_date date
62: ) is
63: select nvl(PTP.start_date, END_OF_TIME) 64: from per_time_periods PTP 65: ,per_assignments_f ASS
66: where ASS.assignment_id = p_assignment_id
67: and p_upload_date between ASS.effective_start_date
68: and ASS.effective_end_date