1383: --
1384: cursor c4 is
1385: select l1.meaning,
1386: l2.meaning
1387: from hr_lookups l1,
1388: hr_lookups l2
1389: where l1.lookup_type = 'YES_NO'
1390: and l2.lookup_type = 'YES_NO'
1391: and l1.lookup_code = 'Y'
1384: cursor c4 is
1385: select l1.meaning,
1386: l2.meaning
1387: from hr_lookups l1,
1388: hr_lookups l2
1389: where l1.lookup_type = 'YES_NO'
1390: and l2.lookup_type = 'YES_NO'
1391: and l1.lookup_code = 'Y'
1392: and l2.lookup_code = 'N' ;