APPS.POS_SPM_WF_PKG1 dependencies on POS_SPMNTF_SUBSCRIPTION

Line 311: FROM fnd_user fu, pos_spmntf_subscription sub

307: l_sql VARCHAR2(1000);
308: BEGIN
309: OPEN x_cur FOR
310: SELECT user_name
311: FROM fnd_user fu, pos_spmntf_subscription sub
312: WHERE fu.user_id = sub.user_id
313: AND sub.event_type = p_event_type;
314: RETURN;
315: END get_buyers;

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

3332: CURSOR l_supplier_users_cur IS
3333: SELECT fu.user_name, fu.email_address
3334: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua
3335: WHERE
3336: fu.user_id in (select spm.user_id from pos_spmntf_subscription spm
3337: where spm.event_type = 'SUPP_BUS_CLASS_RECERT_NTF')
3338: AND fu.person_party_id = hp.party_id
3339: AND fu.email_address IS NOT NULL
3340: AND fu.end_date IS NULL