DBA Data[Home] [Help]

APPS.GMS_AWARD_DELETE_PKG dependencies on GMS_EVENT_ATTRIBUTE

Line 15: FROM gms_event_attribute gea, gms_installments gi

11: p_Err_Stage OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
12:
13: CURSOR event_exist IS
14: SELECT 1 --COUNT(*) bug 2355648
15: FROM gms_event_attribute gea, gms_installments gi
16: WHERE award_id = p_award_id
17: AND gea.installment_id= gi.installment_id
18: AND rownum <=1;
19: l_event_exist number:=0;