APPS.GMS_AWARD_PVT dependencies on GMS_LOOKUPS

Line 949: FROM gms_lookups

945: -- Lookup LOV validations
946: --
947: CURSOR c_lookups( p_lookup_type varchar2, p_code varchar2) is
948: SELECT 1
949: FROM gms_lookups
950: WHERE lookup_type = p_lookup_type
951: and lookup_code = p_code ;
952:
953: -- Allowability Schedule LOV Validation

Line 3108: FROM gms_lookups

3104:
3105:
3106: CURSOR l_installment_type_csr (p_installment_type IN VARCHAR2 ) IS
3107: SELECT 'X'
3108: FROM gms_lookups
3109: WHERE lookup_type = 'INSTALLMENT_TYPE'
3110: AND lookup_code = p_installment_type ;
3111:
3112: -- This is to check the uniqueness of the reference number for that award.

Line 3505: FROM gms_lookups g

3501: -- To validate the incoming award_role parameter.
3502:
3503: CURSOR l_award_role_csr(p_award_role IN VARCHAR2 ) IS
3504: SELECT 'X'
3505: FROM gms_lookups g
3506: WHERE lookup_type = 'AWARD_ROLE'
3507: AND g.lookup_code = p_award_role
3508: AND trunc(sysdate) BETWEEN start_date_active AND nvl(end_date_active,trunc(sysdate)) ;
3509:

Line 4150: FROM gms_lookups

4146: -- and exit the procedure .
4147:
4148: CURSOR l_lookup_csr IS
4149: SELECT 'X'
4150: FROM gms_lookups
4151: WHERE lookup_type = 'REFERENCE_NUMBER'
4152: AND lookup_code = G_reference_number_rec.type ;
4153:
4154: -- ==============================================================================

Line 4619: FROM gms_lookups

4615: AND report_template_id = G_report_rec.report_template_id;
4616:
4617: CURSOR l_valid_frequency_csr IS
4618: SELECT 'X'
4619: FROM gms_lookups
4620: WHERE lookup_type = 'REPORT_FREQUENCY'
4621: AND lookup_code = G_report_rec.frequency;
4622:
4623: CURSOR l_valid_site_code_csr IS