APPS.POS_SPM_WF_PKG1 dependencies on HZ_RELATIONSHIPS

Line 1178: FROM hz_relationships hzr, hz_parties hp, fnd_user fu

1174: IS
1175: l_supplier_party_id NUMBER;
1176: CURSOR l_user_name_cur (p_supplier_party_id IN NUMBER) IS
1177: SELECT fu.user_name
1178: FROM hz_relationships hzr, hz_parties hp, fnd_user fu
1179: WHERE
1180: fu.person_party_id = hp.party_id
1181: AND fu.email_address IS NOT NULL
1182: AND fu.end_date IS NULL

Line 1220: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua

1216: l_adhoc_user wf_roles.name%TYPE;
1217:
1218: CURSOR l_user_name_cur IS
1219: SELECT fu.user_name
1220: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua
1221: WHERE fu.person_party_id = hp.party_id
1222: AND fu.email_address IS NOT NULL
1223: AND fu.end_date IS NULL
1224: AND ap.vendor_id = p_vendor_id

Line 1257: from hz_parties hp, hz_relationships hzr, hz_parties hzr_hp, hz_party_usg_assignments hpua, ap_suppliers apsupp

1253: l_user_name fnd_user.user_name%TYPE;
1254:
1255: CURSOR l_contact_cur IS
1256: select hp.person_first_name, hp.person_last_name, hzr_hp.email_address
1257: from hz_parties hp, hz_relationships hzr, hz_parties hzr_hp, hz_party_usg_assignments hpua, ap_suppliers apsupp
1258: where hp.party_id = hzr.subject_id
1259: and hzr.object_id = apsupp.party_id
1260: and apsupp.vendor_id = p_vendor_id
1261: and hzr.relationship_type = 'CONTACT'

Line 1997: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua

1993: select DISTINCT fu.user_name
1994: from fnd_user fu,
1995: fnd_responsibility fr,
1996: fnd_user_resp_groups_direct furg,
1997: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua
1998: where fr.menu_id IN
1999: (SELECT fme.menu_id
2000: FROM fnd_menu_entries fme
2001: START WITH fme.function_id = l_function_id

Line 3541: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua

3537: );
3538:
3539: CURSOR l_supplier_users_cur IS
3540: SELECT fu.user_name, fu.email_address
3541: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua
3542: WHERE
3543: fu.user_id in (select spm.user_id from pos_spmntf_subscription spm
3544: where spm.event_type = 'SUPP_BUS_CLASS_RECERT_NTF')
3545: AND fu.person_party_id = hp.party_id