eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_APPLICANT_INTERNAL dependencies on PER_BUSINESS_GROUPS

Line 53: FROM per_business_groups_perf pbg

49: l_applicant_number := p_applicant_number;
50: --
51: SELECT pbg.method_of_generation_apl_num
52: INTO l_method_of_generation
53: FROM per_business_groups_perf pbg
54: WHERE pbg.business_group_id = p_business_group_id;
55: --
56:
57: if l_method_of_generation = 'M' and l_applicant_number IS NULL then

Line 2068: l_organization_id per_business_groups.organization_id%type;

2064: l_business_group_id per_people_f.business_group_id%type;
2065: l_name_combination_warning boolean;
2066: l_dob_null_warning boolean;
2067: l_orig_hire_warning boolean;
2068: l_organization_id per_business_groups.organization_id%type;
2069: l_legislation_code per_business_groups.legislation_code%type;
2070: l_person_type_id per_people_f.person_type_id%type;
2071: l_application_id per_applications.application_id%type;
2072: l_comment_id per_assignments_f.comment_id%type;

Line 2069: l_legislation_code per_business_groups.legislation_code%type;

2065: l_name_combination_warning boolean;
2066: l_dob_null_warning boolean;
2067: l_orig_hire_warning boolean;
2068: l_organization_id per_business_groups.organization_id%type;
2069: l_legislation_code per_business_groups.legislation_code%type;
2070: l_person_type_id per_people_f.person_type_id%type;
2071: l_application_id per_applications.application_id%type;
2072: l_comment_id per_assignments_f.comment_id%type;
2073: l_assignment_sequence per_assignments_f.assignment_sequence%type;

Line 2088: l_default_start_time per_business_groups.default_start_time%type;

2084: l_system_person_type per_person_types.system_person_type%type;
2085: l_effective_date date;
2086: l_effective_start_date date;
2087: l_effective_end_date date;
2088: l_default_start_time per_business_groups.default_start_time%type;
2089: l_default_end_time per_business_groups.default_end_time%type;
2090: l_normal_hours number;
2091: l_frequency per_business_groups.frequency%type;
2092: l_recruiter_id per_vacancies.recruiter_id%type;

Line 2089: l_default_end_time per_business_groups.default_end_time%type;

2085: l_effective_date date;
2086: l_effective_start_date date;
2087: l_effective_end_date date;
2088: l_default_start_time per_business_groups.default_start_time%type;
2089: l_default_end_time per_business_groups.default_end_time%type;
2090: l_normal_hours number;
2091: l_frequency per_business_groups.frequency%type;
2092: l_recruiter_id per_vacancies.recruiter_id%type;
2093: l_grade_id per_vacancies.grade_id%type;

Line 2091: l_frequency per_business_groups.frequency%type;

2087: l_effective_end_date date;
2088: l_default_start_time per_business_groups.default_start_time%type;
2089: l_default_end_time per_business_groups.default_end_time%type;
2090: l_normal_hours number;
2091: l_frequency per_business_groups.frequency%type;
2092: l_recruiter_id per_vacancies.recruiter_id%type;
2093: l_grade_id per_vacancies.grade_id%type;
2094: l_position_id per_vacancies.position_id%type;
2095: l_job_id per_vacancies.job_id%type;

Line 2145: from per_business_groups

2141: ,default_start_time
2142: ,default_end_time
2143: ,fnd_number.canonical_to_number(working_hours)
2144: ,frequency
2145: from per_business_groups
2146: where business_group_id = l_business_group_id;
2147: --
2148: -- Get vacancy information.
2149: --