DBA Data[Home] [Help]

APPS.HR_FR_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 45: l_full_name per_all_people_f.full_name%type;

41: ,p_per_information30 in VARCHAR2
42: )
43: RETURN VARCHAR2 IS
44: --
45: l_full_name per_all_people_f.full_name%type;
46: --
47: BEGIN
48: --
49: -- l_full_name := p_title || ' ' || p_last_name || ' ' || p_first_name;

Line 101: l_order_name per_all_people_f.order_name%type;

97: ,p_per_information30 in VARCHAR2
98: )
99: RETURN VARCHAR2 IS
100: --
101: l_order_name per_all_people_f.order_name%type;
102: --
103: BEGIN
104: --
105: l_order_name := substr(p_last_name || ' ' || p_first_name,1,240);