APPS.PV_PG_MEMBERSHIPS_PVT dependencies on PV_ENTY_ATTR_VALUES

Line 1965: FROM pv_enty_attr_values enty

1961:
1962:
1963: CURSOR memb_type_csr(ptr_id NUMBER) IS
1964: SELECT enty.attr_value
1965: FROM pv_enty_attr_values enty
1966: WHERE enty.entity = 'PARTNER'
1967: AND enty.entity_id = ptr_id
1968: AND enty.attribute_id = 6
1969: AND enty.latest_flag = 'Y';

Line 1977: , pv_enty_attr_values subs_enty_val

1973: CURSOR c_get_subs_csr (g_ptr_id NUMBER) IS
1974: SELECT subs_prof.partner_id
1975: FROM pv_partner_profiles subs_prof
1976: , pv_partner_profiles global_prof
1977: , pv_enty_attr_values subs_enty_val
1978: , hz_relationships rel
1979: WHERE global_prof.partner_id = g_ptr_id
1980: AND global_prof.partner_party_id = rel.subject_id
1981: AND rel.relationship_type = 'PARTNER_HIERARCHY'

Line 2520: , pv_enty_attr_values subs_enty_val

2516: , memb.membership_id
2517: , memb.partner_id
2518: FROM pv_partner_profiles subs_prof
2519: , pv_partner_profiles global_prof
2520: , pv_enty_attr_values subs_enty_val
2521:
2522: , hz_relationships rel
2523: , pv_pg_memberships memb
2524: , pv_pg_enrl_requests enrq

Line 2560: , pv_enty_attr_values enty

2556: SELECT enty.attr_value
2557: , memb.program_id
2558: , memb.partner_id
2559: FROM pv_pg_memberships memb
2560: , pv_enty_attr_values enty
2561: WHERE memb.membership_id = memb_id
2562: AND memb.partner_id = enty.entity_id
2563: AND enty.entity = 'PARTNER'
2564: AND enty.entity_id = memb.partner_id

Line 3461: , pv_enty_attr_values enty

3457: , memb.object_version_number
3458: , enty.attr_value
3459: , memb.original_end_date
3460: FROM pv_pg_memberships memb
3461: , pv_enty_attr_values enty
3462: WHERE memb.membership_id=memb_id
3463: AND memb.partner_id=enty.entity_id
3464: AND enty.entity = 'PARTNER'
3465: AND enty.entity_id = memb.partner_id

Line 3480: , pv_enty_attr_values subs_enty_val

3476: , memb.partner_id
3477: , memb.program_id
3478: FROM pv_partner_profiles subs_prof
3479: , pv_partner_profiles global_prof
3480: , pv_enty_attr_values subs_enty_val
3481: , hz_relationships rel
3482: , pv_pg_memberships memb
3483: , pv_pg_enrl_requests enrl
3484: WHERE global_prof.partner_id = global_partner_id