APPS.PV_PRGM_APPROVAL_PVT dependencies on PV_ENTY_ATTR_VALUES

Line 97: FROM pv_enty_attr_values

93: CURSOR partnerType_cur(p_part_id number,p_ptr_type varchar2) IS
94: SELECT 'Y'
95: FROM DUAL
96: WHERE EXISTS (SELECT 1
97: FROM pv_enty_attr_values
98: WHERE entity = 'PARTNER'
99: AND attribute_id = 3
100: AND latest_flag = 'Y'
101: AND entity_id = p_part_id

Line 352: FROM pv_enty_attr_values

348: WHERE enrl_request_id=p_enrl_req_id;
349:
350: CURSOR memb_type_cur(p_ptnr_id IN NUMBER) IS
351: SELECT attr_value
352: FROM pv_enty_attr_values
353: WHERE entity_id=p_ptnr_id
354: AND attribute_id=6
355: AND latest_flag='Y'
356: AND entity='PARTNER';

Line 5274: FROM pv_enty_attr_values enty

5270: AND enrq.invite_header_id=invite.invite_header_id;
5271:
5272: CURSOR c_memb_type_csr(ptr_id NUMBER) IS
5273: SELECT enty.attr_value
5274: FROM pv_enty_attr_values enty
5275: WHERE enty.entity = 'PARTNER'
5276: AND enty.entity_id = ptr_id
5277: AND enty.attribute_id = 6
5278: AND enty.latest_flag = 'Y';