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 1372: FROM pa_agreement_types

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