APPS.GMS_WF_PKG dependencies on GMS_PERSONNEL

Line 3427: from gms_personnel gmsp

3423: --user_id will always bring a unique person_id
3424: cursor chk_person_exists ( p_person_id Number )
3425: is
3426: select 1
3427: from gms_personnel gmsp
3428: where gmsp.award_id = p_award_id
3429: and gmsp.person_id = p_person_id;
3430: /*******
3431: and gmsp.person_id in

Line 3461: from gms_personnel

3457: --Only person active will receive notification
3458: cursor chk_person_active ( p_person_id NUMBER)
3459: is
3460: select 1
3461: from gms_personnel
3462: where person_id = p_person_id
3463: and award_id = p_award_id
3464: and trunc(sysdate) between start_date_active
3465: and nvl(end_date_active,to_date('12/31/4712','MM/DD/YYYY'));