DBA Data[Home] [Help]

APPS.CN_ADD_TBH_PVT dependencies on CN_SRP_HR_DATA

Line 190: from cn_srp_hr_data

186: res number := 1;
187:
188: cursor tbh_nums is
189: select to_number(replace(emp_num,tbh_pre,'')) n
190: from cn_srp_hr_data
191: where emp_num like tbh_pre || '%'
192: and emp_num not like tbh_pre || '%-%'
193: and category = 'TBH'
194: order by n;