DBA Data[Home] [Help]

APPS.GMS_AWARD_PVT dependencies on PA_AGREEMENT_TYPES

Line 1298: x_agreement_type pa_agreement_types.agreement_type%TYPE ;

1294: --
1295: PROCEDURE validate_award( X_return_status IN out NOCOPY varchar2) IS
1296:
1297: x_dummy number := 0;
1298: x_agreement_type pa_agreement_types.agreement_type%TYPE ;
1299: x_awd_snm gms_awards_all.award_short_name%TYPE;
1300: L_error BOOLEAN := FALSE ;
1301:
1302: Project_Check NUMBER(2) := 0;

Line 1373: FROM pa_agreement_types

1369: */
1370:
1371: cursor C_agreement is
1372: SELECT agreement_type
1373: FROM pa_agreement_types
1374: WHERE agreement_type = g_award_rec.type ;
1375:
1376: -- Debashis. Added exists clause. Removed rownum.
1377: CURSOR C_fnd_user is