DBA Data[Home] [Help]

APPS.GMS_WF_PKG dependencies on GMS_NOTIFICATIONS_V

Line 2255: from gms_notifications_v

2251: cursor c2 (p_award_id NUMBER,
2252: p_event_type VARCHAR2)
2253: is
2254: select user_id, user_name
2255: from gms_notifications_v
2256: where event_type like p_event_type
2257: and award_id = p_award_id;
2258:
2259: l_award_id number;

Line 2464: from gms_notifications_v

2460:
2461: cursor c1 (p_award_id IN NUMBER)
2462: is
2463: select user_id, user_name
2464: from gms_notifications_v
2465: where event_type = 'INSTALLMENT_ACTIVE'
2466: and award_id = p_award_id;
2467:
2468: begin