DBA Data[Home] [Help]

APPS.PAY_MX_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 58: ,per_assignments_f ASS

54: ,p_upload_date date
55: ) is
56: select nvl(PTP.start_date, END_OF_TIME)
57: from per_time_periods PTP
58: ,per_assignments_f ASS
59: where ASS.assignment_id = p_assignment_id
60: and p_upload_date between ASS.effective_start_date
61: and ASS.effective_end_date
62: and PTP.payroll_id = ASS.payroll_id