DBA Data[Home] [Help]

APPS.HR_H2PI_VALIDATE dependencies on PER_BUSINESS_GROUPS

Line 60: l_method_of_gen_emp_num per_business_groups.method_of_generation_emp_num%TYPE;

56: l_record_ok BOOLEAN;
57:
58: l_proc VARCHAR2(72) := g_package||'validate_bg_and_gre';
59:
60: l_method_of_gen_emp_num per_business_groups.method_of_generation_emp_num%TYPE;
61: BEGIN
62: hr_utility.set_location('Entering:'|| l_proc, 10);
63: BEGIN
64: SELECT method_of_generation_emp_num

Line 66: FROM per_business_groups

62: hr_utility.set_location('Entering:'|| l_proc, 10);
63: BEGIN
64: SELECT method_of_generation_emp_num
65: INTO l_method_of_gen_emp_num
66: FROM per_business_groups
67: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
68: IF l_method_of_gen_emp_num <> 'M' THEN
69: hr_h2pi_error.data_error(p_from_id => p_from_client_id,
70: p_table_name => 'HR_H2PI_BG_AND_GRE',