APPS.POS_SPM_WF_PKG1 dependencies on POS_SPMNTF_SUBSCRIPTION

Line 363: FROM fnd_user fu, pos_spmntf_subscription sub

359: l_sql VARCHAR2(1000);
360: BEGIN
361: OPEN x_cur FOR
362: SELECT user_name
363: FROM fnd_user fu, pos_spmntf_subscription sub
364: WHERE fu.user_id = sub.user_id
365: AND sub.event_type = p_event_type;
366: RETURN;
367: END get_buyers;

Line 3543: fu.user_id in (select spm.user_id from pos_spmntf_subscription spm

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
3546: AND fu.email_address IS NOT NULL
3547: --AND (fu.end_date IS NULL OR fu.end_date >= SYSDATE) /* bug 8647019 */