DBA Data[Home] [Help]

APPS.ASO_APR_INT dependencies on PER_ALL_PEOPLE_F

Line 20: FROM per_all_people_f

16: CURSOR get_person_name (
17: c_person_id NUMBER
18: ) IS
19: SELECT full_name
20: FROM per_all_people_f
21: WHERE person_id = c_person_id
22: AND SYSDATE BETWEEN effective_start_date
23: AND NVL (
24: effective_end_date,

Line 110: 'person_id ' || l_person_id || ' does not exist in per_all_people_f',

106: END LOOP;
107:
108: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
109: aso_debug_pub.ADD (
110: 'person_id ' || l_person_id || ' does not exist in per_all_people_f',
111: 1,
112: 'N'
113: );
114: END IF;