APPS.GMS_WF_PKG dependencies on GMS_LOOKUPS

Line 2821: l_header gms_lookups.meaning%TYPE;

2817: l_task_id gms_encumbrance_items.task_id%TYPE;
2818: l_installment_end_date gms_installments.start_date_active%TYPE;
2819: l_installment_start_date gms_installments.end_date_active%TYPE;
2820: l_installment_id gms_installments.installment_id%TYPE;
2821: l_header gms_lookups.meaning%TYPE;
2822: l_award_number gms_awards.award_number%TYPE;
2823: l_installment_number gms_installments.installment_num%TYPE;
2824: -- Declare a variable to create a new line.
2825: NL VARCHAR2(1) := fnd_global.newline;

Line 2830: FROM gms_lookups

2826: -- Cursor to fetch all the open commitments attached associated with the award ,project and task combination
2827:
2828: CURSOR lookups_cursor (type VARCHAR2) IS
2829: SELECT meaning
2830: FROM gms_lookups
2831: WHERE lookup_type='GMS_COMMT_TYPE'
2832: AND lookup_code = type ;
2833:
2834:

Line 2837: FROM gms_lookups

2833:
2834:
2835: CURSOR lookup_document (header VARCHAR2) IS
2836: SELECT meaning
2837: FROM gms_lookups
2838: WHERE lookup_type='GMS_DOC_NOTIF'
2839: AND lookup_code = header ;
2840:
2841: /*