DBA Data[Home] [Help]

APPS.HR_H2PI_ERROR dependencies on PER_BUSINESS_GROUPS

Line 153: l_to_business_group_name per_business_groups.name%type;

149: from_id,
150: api_module_id;
151:
152: l_row_count NUMBER(15) := 0;
153: l_to_business_group_name per_business_groups.name%type;
154: l_text VARCHAR2(2000);
155: l_table_name hr_h2pi_message_lines.table_name%type := ' ';
156: --l_from_business_group_id hr_h2pi_message_lines.to_business_group_id%type;
157: l_from_client_id hr_h2pi_message_lines.to_business_group_id%type;

Line 163: FROM per_business_groups

159: BEGIN
160: BEGIN
161: SELECT name
162: INTO l_to_business_group_name
163: FROM per_business_groups
164: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
165: EXCEPTION
166: WHEN NO_DATA_FOUND THEN
167: fnd_file.put_line(FND_FILE.LOG,