DBA Data[Home] [Help]

APPS.HR_H2PI_MAP dependencies on HR_H2PI_UPLOAD

Line 49: SELECT distinct hr_h2pi_upload.g_to_business_group_id,

45: END IF;
46:
47: INSERT INTO hr_h2pi_id_mapping
48: (to_business_group_id, from_id, to_id, table_name)
49: SELECT distinct hr_h2pi_upload.g_to_business_group_id,
50: p_from_id,
51: p_to_id,
52: p_table_name
53: FROM hr_h2pi_id_mapping im1

Line 57: hr_h2pi_upload.g_to_business_group_id

53: FROM hr_h2pi_id_mapping im1
54: WHERE NOT EXISTS (SELECT 1
55: FROM hr_h2pi_id_mapping im2
56: WHERE to_business_group_id =
57: hr_h2pi_upload.g_to_business_group_id
58: AND from_id = p_from_id
59: AND to_id = p_to_id
60: AND table_name = p_table_name);
61: hr_utility.set_location('Leaving:'|| l_proc, 50);

Line 100: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id

96: END IF;
97:
98: SELECT to_id INTO l_to_id
99: FROM hr_h2pi_id_mapping
100: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id
101: AND table_name = p_table_name
102: AND from_id = p_from_id;
103: RETURN l_to_id;
104:

Line 154: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id

150: END IF;
151:
152: SELECT from_id INTO l_from_id
153: FROM hr_h2pi_id_mapping
154: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id
155: AND table_name = p_table_name
156: AND to_id = p_to_id;
157:
158: RETURN l_from_id;