156: --modified the cursor for the performance bug 3693713
157: --this cursor is used to check statistics record which is created with person record
158: CURSOR c_ps IS
159: SELECT 'x' 160: FROM HZ_PARTIES ps 161: WHERE ps.party_id = p_person_id ;
162:
163: CURSOR c_pal IS
164: SELECT 'x'