APPS.PV_PG_MEMBERSHIPS_PVT dependencies on PV_PARTNER_PROFILES

Line 1495: FROM pv_partner_profiles

1491: l_relationship VARCHAR2(15);
1492:
1493: CURSOR pstatus_cur(p_ptr_id NUMBER) IS
1494: SELECT status
1495: FROM pv_partner_profiles
1496: WHERE partner_id=p_ptr_id;
1497:
1498: BEGIN
1499: l_default_program_id:= isnumber(FND_PROFILE.VALUE('PV_PARTNER_DEFAULT_PROGRAM'));

Line 1700: FROM pv_partner_profiles

1696: ) IS
1697:
1698: CURSOR pstatus_cur(p_ptr_id NUMBER) IS
1699: SELECT status
1700: FROM pv_partner_profiles
1701: WHERE partner_id=p_ptr_id;
1702:
1703: CURSOR contract_cur(mmbr_id NUMBER) IS
1704: SELECT contract_id

Line 1975: FROM pv_partner_profiles subs_prof

1971: -- fix this SQL 12266991
1972: -- Fix this SQL 12267007
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

Line 1976: , pv_partner_profiles global_prof

1972: -- Fix this SQL 12267007
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

Line 2518: FROM pv_partner_profiles subs_prof

2514: , enrq.request_status_code
2515: , memb.membership_status_code
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

Line 2519: , pv_partner_profiles global_prof

2515: , memb.membership_status_code
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

Line 3478: FROM pv_partner_profiles subs_prof

3474: , memb.object_version_number
3475: , memb.original_end_date
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

Line 3479: , pv_partner_profiles global_prof

3475: , memb.original_end_date
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