APPS.PER_PJU_BUS dependencies on PER_PREVIOUS_EMPLOYERS

Line 44: in per_previous_employers.previous_employer_id%type

40: -- {End Of Comments}
41: -- ----------------------------------------------------------------------------
42: procedure chk_previous_employer_id
43: (p_previous_employer_id
44: in per_previous_employers.previous_employer_id%type
45: ,p_previous_job_usage_id
46: in per_previous_job_usages.previous_job_usage_id%type
47: ,p_object_version_number
48: in per_previous_job_usages.object_version_number%type) is

Line 51: from per_previous_employers

47: ,p_object_version_number
48: in per_previous_job_usages.object_version_number%type) is
49: cursor csr_previous_employer_id is
50: select previous_employer_id
51: from per_previous_employers
52: where previous_employer_id = p_previous_employer_id
53: and all_assignments = 'N';
54: l_previous_employer_id per_previous_employers.previous_employer_id%type;
55: --

Line 54: l_previous_employer_id per_previous_employers.previous_employer_id%type;

50: select previous_employer_id
51: from per_previous_employers
52: where previous_employer_id = p_previous_employer_id
53: and all_assignments = 'N';
54: l_previous_employer_id per_previous_employers.previous_employer_id%type;
55: --
56: l_proc varchar2(72) := g_package||'chk_previous_employer_id';
57: l_api_updating boolean;
58: begin

Line 573: from per_previous_employers

569: ,p_end_date
570: in per_previous_job_usages.end_date%type) is
571: cursor csr_pem_start_end_dates is
572: select previous_employer_id
573: from per_previous_employers
574: where previous_employer_id = p_previous_employer_id
575: and ( p_start_date not between nvl(start_date,hr_api.g_sot)
576: and nvl(end_date,hr_api.g_eot)
577: or p_end_date not between nvl(start_date,hr_api.g_sot)

Line 579: l_previous_employer_id per_previous_employers.previous_employer_id%type;

575: and ( p_start_date not between nvl(start_date,hr_api.g_sot)
576: and nvl(end_date,hr_api.g_eot)
577: or p_end_date not between nvl(start_date,hr_api.g_sot)
578: and nvl(end_date,hr_api.g_eot));
579: l_previous_employer_id per_previous_employers.previous_employer_id%type;
580: --
581: l_api_updating boolean;
582: l_proc varchar2(72) := g_package||'chk_pju_start_end_dates';
583: begin

Line 892: , per_previous_employers pem

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
896: and pbg.business_group_id = pem.business_group_id;

Line 954: , per_previous_employers pem

950: cursor csr_leg_code is
951: select pbg.legislation_code
952: from per_business_groups pbg
953: , per_previous_job_usages pju
954: , per_previous_employers pem
955: where pju.previous_job_usage_id = p_previous_job_usage_id
956: and pju.previous_employer_id = pem.previous_employer_id(+)
957: and pem.business_group_id = pbg.business_group_id(+);
958: --