1440: l_exists VARCHAR2(1);
1441:
1442: CURSOR partner_program_cur(l_program_type_id in number) is
1443: SELECT 'x' FROM DUAL WHERE EXISTS (
1444: SELECT 'x' FROM PV_PARTNER_PROGRAM_B
1445: WHERE PROGRAM_TYPE_ID = l_program_type_id
1446: AND PROGRAM_STATUS_CODE NOT IN ('CANCEL', 'CLOSED','ARCHIVE')
1447: AND ENABLED_FLAG = 'Y'
1448: );
1478: l_exists VARCHAR2(1);
1479:
1480: CURSOR partner_program_cur(l_program_type_id in number) is
1481: SELECT 'x' FROM DUAL WHERE EXISTS (
1482: SELECT 'x' FROM PV_PARTNER_PROGRAM_B
1483: WHERE PROGRAM_TYPE_ID = l_program_type_id
1484: AND ENABLED_FLAG = 'Y'
1485: );
1486: