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:
2825: l_installment_end_date_text varchar2(60); /*Added for bug:7538344 */

Line 2834: FROM gms_lookups

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

Line 2841: FROM gms_lookups

2837:
2838:
2839: CURSOR lookup_document (header VARCHAR2) IS
2840: SELECT meaning
2841: FROM gms_lookups
2842: WHERE lookup_type='GMS_DOC_NOTIF'
2843: AND lookup_code = header ;
2844:
2845: /*