APPS.GMS_AWARD_PVT dependencies on DUAL

Line 1377: select 1 from dual where exists (

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

Line 1787: from DUAL ;

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

Line 3369: FROM dual;

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

Line 3827: FROM DUAL ;

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

Line 4814: FROM dual ;

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

Line 5556: FROM dual;

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