Line 55: where p_category in ('ACTIVE','INACTIVE','STANDARD','CANCELED');
51:
52: cursor c_pd_category is
53: select 'X' from
54: dual 55: where p_category in ('ACTIVE','INACTIVE','STANDARD','CANCELED'); 56:
57: BEGIN
58:
59: hr_utility.set_location('Entering: '|| l_proc, 10);