APPS.GMS_AWARD_PVT dependencies on DUAL

Line 1378: select 1 from dual where exists (

1374: WHERE agreement_type = g_award_rec.type ;
1375:
1376: -- Debashis. Added exists clause. Removed rownum.
1377: CURSOR C_fnd_user is
1378: select 1 from dual where exists (
1379: select user_id
1380: from fnd_user
1381: where employee_id = g_award_rec.award_manager_id);
1382: -- and rownum = 1 ;

Line 1788: from DUAL ;

1784: L_agreement_id NUMBER ;
1785: BEGIN
1786: select gms_awards_s.NEXTVAL
1787: into g_award_rec.award_id
1788: from DUAL ;
1789:
1790: create_agreement(L_agreement_id ) ;
1791:
1792: g_award_rec.agreement_id := L_agreement_id ;

Line 3370: FROM dual;

3366:
3367:
3368: SELECT gms_installments_s.nextval
3369: INTO G_installment_rec.installment_id
3370: FROM dual;
3371:
3372: G_stage := 'FND_API.Create_Installment' ;
3373:
3374: gms_installments_pkg.insert_row(

Line 3829: FROM DUAL ;

3825:
3826:
3827: SELECT gms_personnel_s.nextval
3828: INTO G_personnel_rec.personnel_id
3829: FROM DUAL ;
3830:
3831: G_stage := 'FND_API.Create_Personnel_Record' ;
3832: gms_personnel_pkg.insert_row
3833: ( x_rowid => L_rowid,

Line 4816: FROM dual ;

4812: G_stage := 'gms_default_reports_pkg.insert_row' ;
4813:
4814: SELECT gms_default_reports_s.nextval
4815: INTO G_report_rec.default_report_id
4816: FROM dual ;
4817:
4818: -- ========================================
4819: -- Calling Table Handler to Insert the Row.
4820: -- ========================================

Line 5558: FROM dual;

5554: G_stage := 'gms_project_fundings_pkg.insert_row' ;
5555:
5556: SELECT gms_project_fundings_s.nextval
5557: INTO x_gms_project_funding_id
5558: FROM dual;
5559:
5560: GMS_PROJECT_FUNDINGS_PKG.INSERT_ROW(
5561: X_ROWID => l_rowid,
5562: X_GMS_PROJECT_FUNDING_ID => x_gms_project_funding_id,