APPS.PER_PJO_BUS dependencies on PER_PREVIOUS_EMPLOYERS

Line 33: , per_previous_employers pem

29: select pbg.security_group_id
30: from per_business_groups pbg
31: , per_previous_jobs pjo
32: , per_all_people_f ppf
33: , per_previous_employers pem
34: where pjo.previous_job_id = p_previous_job_id
35: and pbg.business_group_id = ppf.business_group_id
36: and pem.person_id = ppf.person_id
37: and pem.previous_employer_id = pjo.previous_employer_id;

Line 100: , per_previous_employers pem

96: select pbg.legislation_code
97: from per_business_groups pbg
98: , per_previous_jobs pjo
99: , per_all_people_f ppf
100: , per_previous_employers pem
101: where pjo.previous_job_id = p_previous_job_id
102: and ppf.business_group_id = pbg.business_group_id(+)
103: and pem.person_id = ppf.person_id(+)
104: and pjo.previous_employer_id = pem.previous_employer_id;

Line 619: from per_previous_employers

615: ,p_object_version_number
616: in per_previous_jobs.object_version_number%type) is
617: cursor csr_previous_employer_id is
618: select previous_employer_id
619: from per_previous_employers
620: where previous_employer_id = p_previous_employer_id;
621: l_previous_employer_id per_previous_employers.previous_employer_id%type;
622: --
623: l_proc varchar2(72) := g_package||'chk_previous_employer_id';

Line 621: l_previous_employer_id per_previous_employers.previous_employer_id%type;

617: cursor csr_previous_employer_id is
618: select previous_employer_id
619: from per_previous_employers
620: where previous_employer_id = p_previous_employer_id;
621: l_previous_employer_id per_previous_employers.previous_employer_id%type;
622: --
623: l_proc varchar2(72) := g_package||'chk_previous_employer_id';
624: l_api_updating boolean;
625: begin

Line 1092: from per_previous_employers

1088: ,p_effective_date
1089: IN per_previous_jobs.start_date%type) is
1090: cursor csr_pem_start_end_dates is
1091: select previous_employer_id
1092: from per_previous_employers
1093: where previous_employer_id = p_previous_employer_id
1094: and (p_start_date not between nvl(start_date,hr_api.g_sot)
1095: and nvl(end_date,hr_api.g_eot)
1096: or p_end_date not between nvl(start_date,hr_api.g_sot)

Line 1098: l_previous_employer_id per_previous_employers.previous_employer_id%type;

1094: and (p_start_date not between nvl(start_date,hr_api.g_sot)
1095: and nvl(end_date,hr_api.g_eot)
1096: or p_end_date not between nvl(start_date,hr_api.g_sot)
1097: and nvl(end_date,hr_api.g_eot));
1098: l_previous_employer_id per_previous_employers.previous_employer_id%type;
1099: --
1100: l_proc varchar2(72) := g_package||'chk_pjo_start_end_dates';
1101: l_api_updating boolean;
1102: begin

Line 1488: per_previous_employers pem

1484: cursor csr_leg_code is
1485: select pbg.legislation_code
1486: from per_business_groups pbg,
1487: per_all_people_f ppf,
1488: per_previous_employers pem
1489: where pem.previous_employer_id = p_previous_employer_id
1490: and ppf.business_group_id = pbg.business_group_id(+)
1491: and pem.person_id = ppf.person_id(+);
1492: --