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 2285: l_organization_id per_business_groups.organization_id%type;

2281: l_business_group_id per_people_f.business_group_id%type;
2282: l_name_combination_warning boolean;
2283: l_dob_null_warning boolean;
2284: l_orig_hire_warning boolean;
2285: l_organization_id per_business_groups.organization_id%type;
2286: l_legislation_code per_business_groups.legislation_code%type;
2287: l_person_type_id per_people_f.person_type_id%type;
2288: l_application_id per_applications.application_id%type;
2289: l_comment_id per_assignments_f.comment_id%type;

Line 2286: l_legislation_code per_business_groups.legislation_code%type;

2282: l_name_combination_warning boolean;
2283: l_dob_null_warning boolean;
2284: l_orig_hire_warning boolean;
2285: l_organization_id per_business_groups.organization_id%type;
2286: l_legislation_code per_business_groups.legislation_code%type;
2287: l_person_type_id per_people_f.person_type_id%type;
2288: l_application_id per_applications.application_id%type;
2289: l_comment_id per_assignments_f.comment_id%type;
2290: l_assignment_sequence per_assignments_f.assignment_sequence%type;

Line 2305: l_default_start_time per_business_groups.default_start_time%type;

2301: l_system_person_type per_person_types.system_person_type%type;
2302: l_effective_date date;
2303: l_effective_start_date date;
2304: l_effective_end_date date;
2305: l_default_start_time per_business_groups.default_start_time%type;
2306: l_default_end_time per_business_groups.default_end_time%type;
2307: l_normal_hours number;
2308: l_frequency per_business_groups.frequency%type;
2309: l_recruiter_id per_vacancies.recruiter_id%type;

Line 2306: l_default_end_time per_business_groups.default_end_time%type;

2302: l_effective_date date;
2303: l_effective_start_date date;
2304: l_effective_end_date date;
2305: l_default_start_time per_business_groups.default_start_time%type;
2306: l_default_end_time per_business_groups.default_end_time%type;
2307: l_normal_hours number;
2308: l_frequency per_business_groups.frequency%type;
2309: l_recruiter_id per_vacancies.recruiter_id%type;
2310: l_grade_id per_vacancies.grade_id%type;

Line 2308: l_frequency per_business_groups.frequency%type;

2304: l_effective_end_date date;
2305: l_default_start_time per_business_groups.default_start_time%type;
2306: l_default_end_time per_business_groups.default_end_time%type;
2307: l_normal_hours number;
2308: l_frequency per_business_groups.frequency%type;
2309: l_recruiter_id per_vacancies.recruiter_id%type;
2310: l_grade_id per_vacancies.grade_id%type;
2311: l_position_id per_vacancies.position_id%type;
2312: l_job_id per_vacancies.job_id%type;

Line 2362: from per_business_groups

2358: ,default_start_time
2359: ,default_end_time
2360: ,fnd_number.canonical_to_number(working_hours)
2361: ,frequency
2362: from per_business_groups
2363: where business_group_id = l_business_group_id;
2364: --
2365: -- Get vacancy information.
2366: --