APPS.PV_ENRQ_BINS_PVT dependencies on PV_PROGRAM_PARTNER_TYPES

Line 177: SELECT 'X' FROM pv_program_partner_types pvppt

173: AND pvpptb.enabled_flag = 'Y'
174: -- AND inv.invite_type_code(+)='INVITE'
175: AND EXISTS
176: (
177: SELECT 'X' FROM pv_program_partner_types pvppt
178: WHERE pvppt.partner_type IN
179: (
180: SELECT attr_value
181: FROM pv_enty_attr_values pveav

Line 240: SELECT 'X' FROM pv_program_partner_types pvppt

236: AND pvpptb.ACTIVE_FLAG = 'Y'
237: AND pvpptb.enabled_flag = 'Y'
238: AND EXISTS
239: (
240: SELECT 'X' FROM pv_program_partner_types pvppt
241: WHERE pvppt.partner_type IN
242: (
243: SELECT attr_value
244: FROM pv_enty_attr_values pveav

Line 528: ( SELECT 'X' FROM pv_program_partner_types pvppt

524: --AND inv.invite_for_program_id (+) = pvppb.program_id
525: -- AND NVL(inv.invite_end_date, sysdate+1) > sysdate
526: --AND inv.invite_type_code(+)='INVITE'
527: AND EXISTS
528: ( SELECT 'X' FROM pv_program_partner_types pvppt
529: WHERE pvppt.partner_type IN
530: (
531: SELECT attr_value
532: FROM pv_enty_attr_values pveav

Line 858: ( SELECT 'X' FROM pv_program_partner_types pvppt

854: AND memb2.membership_status_code in ('ACTIVE','UPGRADED','EXPIRED','FUTURE')
855:
856: )
857: AND EXISTS
858: ( SELECT 'X' FROM pv_program_partner_types pvppt
859: WHERE pvppt.partner_type IN
860: (
861: SELECT attr_value
862: FROM pv_enty_attr_values pveav

Line 1094: FROM pv_program_partner_types pvppt

1090: AND pvppb.program_type_id = pvpptb.program_type_ID AND pvpptb.ACTIVE_FLAG = 'Y'
1091: AND pvpptb.enabled_flag = 'Y'
1092: AND EXISTS
1093: ( SELECT 'X'
1094: FROM pv_program_partner_types pvppt
1095: WHERE pvppt.partner_type
1096: IN ( SELECT attr_value
1097: FROM pv_enty_attr_values pveav
1098: WHERE pveav.enabled_flag = 'Y'

Line 1456: FROM pv_program_partner_types pvppt

1452: )
1453: AND EXISTS
1454: (
1455: SELECT 'X'
1456: FROM pv_program_partner_types pvppt
1457: WHERE pvppt.partner_type IN
1458: (
1459: SELECT attr_value
1460: FROM pv_enty_attr_values pveav

Line 1537: FROM pv_program_partner_types pvppt

1533: )
1534: AND EXISTS
1535: (
1536: SELECT 'X'
1537: FROM pv_program_partner_types pvppt
1538: WHERE pvppt.partner_type IN
1539: (
1540: SELECT attr_value
1541: FROM pv_enty_attr_values pveav