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 3109: FROM gms_lookups

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

Line 3507: FROM gms_lookups g

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

Line 4152: FROM gms_lookups

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

Line 4621: FROM gms_lookups

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