APPS.PER_PJU_BUS dependencies on PER_PREVIOUS_JOBS

Line 123: in per_previous_jobs.previous_job_id%type

119: -- {End Of Comments}
120: -- ----------------------------------------------------------------------------
121: procedure chk_previous_job_id
122: (p_previous_job_id
123: in per_previous_jobs.previous_job_id%type
124: ,p_previous_job_usage_id
125: in per_previous_job_usages.previous_job_usage_id%type
126: ,p_object_version_number
127: in per_previous_job_usages.object_version_number%type) is

Line 130: from per_previous_jobs

126: ,p_object_version_number
127: in per_previous_job_usages.object_version_number%type) is
128: cursor csr_previous_job_id is
129: select previous_job_id
130: from per_previous_jobs
131: where previous_job_id = p_previous_job_id
132: and all_assignments = 'N';
133: l_previous_job_id per_previous_jobs.previous_job_id%type;
134: --

Line 133: l_previous_job_id per_previous_jobs.previous_job_id%type;

129: select previous_job_id
130: from per_previous_jobs
131: where previous_job_id = p_previous_job_id
132: and all_assignments = 'N';
133: l_previous_job_id per_previous_jobs.previous_job_id%type;
134: --
135: l_proc varchar2(72) := g_package||'chk_previous_job_id';
136: l_api_updating boolean;
137: begin

Line 736: -- in per_previous_jobs

732: --
733: --
734: -- Post Failure:
735: -- An application error is raised if previous_job_id is not existing
736: -- in per_previous_jobs
737: --
738: -- {End Of Comments}
739: -- ----------------------------------------------------------------------------
740: procedure get_previous_job_dates

Line 765: from per_previous_jobs pjo

761: ,end_date
762: ,period_years
763: ,period_months
764: ,period_days
765: from per_previous_jobs pjo
766: where pjo.previous_employer_id = p_previous_employer_id
767: and pjo.previous_job_id = p_previous_job_id;
768: --
769: begin

Line 837: select 'x' from per_previous_jobs pjo

833: -- Declare local procedure name
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;

Line 891: , per_previous_jobs pjo

887: cursor csr_sec_grp is
888: select pbg.security_group_id
889: from per_business_groups pbg
890: , per_previous_job_usages pju
891: , per_previous_jobs pjo
892: , per_previous_employers pem
893: where pju.previous_job_usage_id = p_previous_job_usage_id
894: and pju.previous_job_id(+) = pjo.previous_job_id
895: and pjo.previous_employer_id = pem.previous_employer_id