DBA Data[Home] [Help]

APPS.PER_PMP_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1081: -- PER_ALL_ASSIGNMENTS_F.

1077: -- {Start Of Comments}
1078: --
1079: -- Description:
1080: -- Checks that the supervisor assignment is a valid person id
1081: -- PER_ALL_ASSIGNMENTS_F.
1082: --
1083: -- Prerequisites:
1084: -- None.
1085: --

Line 1112: from per_all_assignments_f paf

1108: -- Declare the cursor
1109:
1110: cursor csr_supervisor_assignment_id is
1111: select 'Y'
1112: from per_all_assignments_f paf
1113: where paf.assignment_id = p_supervisor_assignment_id
1114: and p_effective_date between
1115: paf.effective_start_date and paf.effective_end_date;
1116: