APPS.PV_TERR_ASSIGN_PUB dependencies on PV_ENTY_ATTR_VALUES

Line 753: FROM pv_enty_attr_values ATTR

749: -- by checking the partner_type check first and then checking the
750: -- resource.
751: CURSOR l_is_vad_partner_csr(cv_partner_id NUMBER) IS
752: SELECT 'Y'
753: FROM pv_enty_attr_values ATTR
754: WHERE ATTR.entity_id = cv_partner_id
755: AND ATTR.entity= 'PARTNER'
756: AND ATTR.attribute_id = 3
757: AND ATTR.attr_value = 'VAD'

Line 2308: FROM pv_enty_attr_values

2304: -- Cursor l_partner_types_csr, which takes partner_id as an input paramter, and gives
2305: -- the Partners types.
2306: CURSOR l_partner_type_csr (cv_partner_id NUMBER) IS
2307: SELECT attr_value
2308: FROM pv_enty_attr_values
2309: WHERE attribute_id = 3
2310: AND entity= 'PARTNER'
2311: AND entity_id = cv_partner_id
2312: AND latest_flag = 'Y';

Line 3569: FROM pv_enty_attr_values

3565: -- Cursor l_partner_types_csr, which takes partner_id as an input paramter, and gives
3566: -- the Partners types.
3567: CURSOR l_partner_type_csr (cv_partner_id NUMBER) IS
3568: SELECT attr_value
3569: FROM pv_enty_attr_values
3570: WHERE attribute_id = 3
3571: AND entity= 'PARTNER'
3572: AND entity_id = cv_partner_id
3573: AND latest_flag = 'Y';

Line 4135: FROM pv_enty_attr_values

4131: -- Cursor l_partner_types_csr, which takes partner_id as an input paramter, and gives
4132: -- the Partners types.
4133: CURSOR l_partner_type_csr (cv_partner_id NUMBER) IS
4134: SELECT attr_value
4135: FROM pv_enty_attr_values
4136: WHERE attribute_id = 3
4137: AND entity= 'PARTNER'
4138: AND entity_id = cv_partner_id
4139: AND latest_flag = 'Y';

Line 4635: pv_enty_attr_values b

4631: -- VAD Partner id.
4632: CURSOR l_VAD_party_id_csr (cv_vad_partner_id NUMBER) IS
4633: SELECT partner_party_id
4634: FROM pv_partner_profiles a,
4635: pv_enty_attr_values b
4636: WHERE a.partner_id = cv_vad_partner_id
4637: AND a.status = 'A'
4638: AND a.partner_id = b.entity_id
4639: AND b.entity = 'PARTNER'