APPS.PV_ENRQ_BINS_PVT dependencies on PV_ENTY_ATTR_VALUES

Line 181: FROM pv_enty_attr_values pveav

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
182: WHERE pveav.enabled_flag = 'Y'
183: AND pveav.latest_flag = 'Y'
184: AND pveav.entity = 'PARTNER'
185: AND pveav.entity_id = ptnr_id

Line 244: FROM pv_enty_attr_values pveav

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
245: WHERE pveav.enabled_flag = 'Y'
246: AND pveav.latest_flag = 'Y'
247: AND pveav.entity = 'PARTNER'
248: AND pveav.entity_id = ptnr_id

Line 532: FROM pv_enty_attr_values pveav

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
533: WHERE pveav.enabled_flag = 'Y'
534: AND pveav.latest_flag = 'Y'
535: AND pveav.entity = 'PARTNER'
536: AND pveav.entity_id = ptr_id

Line 862: FROM pv_enty_attr_values pveav

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
863: WHERE pveav.enabled_flag = 'Y'
864: AND pveav.latest_flag = 'Y'
865: AND pveav.entity = 'PARTNER'
866: AND pveav.entity_id =p_ptr_id

Line 1097: FROM pv_enty_attr_values pveav

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'
1099: AND pveav.latest_flag = 'Y'
1100: AND pveav.entity = 'PARTNER'
1101: AND pveav.entity_id =p_ptr_id

Line 1429: FROM pv_enty_attr_values

1425: l_enrollment_type_code VARCHAR2(30);
1426:
1427: CURSOR memb_type( p_ptr_id NUMBER) IS
1428: SELECT attr_value
1429: FROM pv_enty_attr_values
1430: WHERE entity='PARTNER'
1431: AND entity_id=p_ptr_id
1432: AND attribute_id=6
1433: AND latest_flag='Y';

Line 1460: FROM pv_enty_attr_values pveav

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
1461: WHERE pveav.enabled_flag = 'Y'
1462: AND pveav.latest_flag = 'Y'
1463: AND pveav.entity = 'PARTNER'
1464: AND pveav.entity_id = ptnr_id

Line 1541: FROM pv_enty_attr_values pveav

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
1542: WHERE pveav.enabled_flag = 'Y'
1543: AND pveav.latest_flag = 'Y'
1544: AND pveav.entity = 'PARTNER'
1545: AND pveav.entity_id = p_ptr_id