DBA Data[Home] [Help]

APPS.PAY_CAL_BUS dependencies on PER_ASSIGNMENTS_F

Line 292: from per_assignments_f paf

288: -- Cursor to check that the assignment exists.
289: --
290: cursor csr_assignment_exists is
291: select 'Y'
292: from per_assignments_f paf
293: where paf.assignment_id = p_assignment_id
294: and p_effective_date between paf.effective_start_date
295: and paf.effective_end_date
296: and paf.business_group_id = p_business_group_id;