DBA Data[Home] [Help]

APPS.PER_PJU_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 209: from per_all_assignments_f

205: ,p_assignment_id
206: in per_previous_job_usages.assignment_id%type) is
207: cursor csr_assignment_id is
208: select assignment_id
209: from per_all_assignments_f
210: where assignment_id = p_assignment_id;
211: l_assignment_id per_previous_job_usages.assignment_id%type;
212: --
213: l_proc varchar2(72) := g_package||'chk_assignment_id';

Line 838: ,per_all_assignments_f asg

834: l_proc varchar2(72) := g_package||'chk_asg_job_start_date';
835: -- Declare local cursors
836: cursor csr_asg_job_start_date is
837: select 'x' from per_previous_jobs pjo
838: ,per_all_assignments_f asg
839: where pjo.start_date >= asg.effective_start_date
840: and pjo.previous_job_id = p_previous_job_id
841: and asg.assignment_id = p_assignment_id;
842: -- Declare local variables