APPS.PER_CEL_BUS dependencies on PER_JOBS

Line 1102: l_business_group_id per_jobs.business_group_id%TYPE;

1098: ,p_qualification_type_id per_competence_elements.qualification_type_id%TYPE
1099: )is
1100: --
1101: l_proc varchar2(72) := g_package||'chk_foreign_keys';
1102: l_business_group_id per_jobs.business_group_id%TYPE;
1103: l_start_date per_jobs.date_from%TYPE;
1104: l_end_date per_jobs.date_to%TYPE;
1105: l_start_date_2 per_jobs.date_from%TYPE;
1106: l_end_date_2 per_jobs.date_to%TYPE;

Line 1103: l_start_date per_jobs.date_from%TYPE;

1099: )is
1100: --
1101: l_proc varchar2(72) := g_package||'chk_foreign_keys';
1102: l_business_group_id per_jobs.business_group_id%TYPE;
1103: l_start_date per_jobs.date_from%TYPE;
1104: l_end_date per_jobs.date_to%TYPE;
1105: l_start_date_2 per_jobs.date_from%TYPE;
1106: l_end_date_2 per_jobs.date_to%TYPE;
1107: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 1104: l_end_date per_jobs.date_to%TYPE;

1100: --
1101: l_proc varchar2(72) := g_package||'chk_foreign_keys';
1102: l_business_group_id per_jobs.business_group_id%TYPE;
1103: l_start_date per_jobs.date_from%TYPE;
1104: l_end_date per_jobs.date_to%TYPE;
1105: l_start_date_2 per_jobs.date_from%TYPE;
1106: l_end_date_2 per_jobs.date_to%TYPE;
1107: l_date_of_birth per_people_f.date_of_birth%TYPE;
1108: l_exist varchar2(1);

Line 1105: l_start_date_2 per_jobs.date_from%TYPE;

1101: l_proc varchar2(72) := g_package||'chk_foreign_keys';
1102: l_business_group_id per_jobs.business_group_id%TYPE;
1103: l_start_date per_jobs.date_from%TYPE;
1104: l_end_date per_jobs.date_to%TYPE;
1105: l_start_date_2 per_jobs.date_from%TYPE;
1106: l_end_date_2 per_jobs.date_to%TYPE;
1107: l_date_of_birth per_people_f.date_of_birth%TYPE;
1108: l_exist varchar2(1);
1109: l_api_updating boolean;

Line 1106: l_end_date_2 per_jobs.date_to%TYPE;

1102: l_business_group_id per_jobs.business_group_id%TYPE;
1103: l_start_date per_jobs.date_from%TYPE;
1104: l_end_date per_jobs.date_to%TYPE;
1105: l_start_date_2 per_jobs.date_from%TYPE;
1106: l_end_date_2 per_jobs.date_to%TYPE;
1107: l_date_of_birth per_people_f.date_of_birth%TYPE;
1108: l_exist varchar2(1);
1109: l_api_updating boolean;
1110: l_party_id per_competence_elements.party_id%TYPE; -- HR/TCA merge

Line 1119: from per_jobs_v

1115: --
1116: cursor csr_valid_job_id is
1117:
1118: select business_group_id,date_from,date_to
1119: from per_jobs_v
1120: where p_job_id = job_id;
1121: --and p_effective_date_from >= date_from
1122: --and nvl(p_effective_date_to,hr_api.g_eot)<=
1123: -- nvl(date_to,hr_api.g_eot);