APPS.GMS_MULTI_FUNDING dependencies on DUAL

Line 152: FROM dual)

148: X_Agreement_Id,
149: SYSDATE,
150: fnd_global.user_id,
151: fnd_global.login_id
152: FROM dual)
153: WHERE AWARD_ID = X_Award_Id;
154:
155: END UPDATE_GMS_AWARDS;
156:

Line 552: FROM dual;

548: BEGIN
549: St_Billing_Offset := 0;
550: SELECT decode(X_Billing_Frequency,'ANNUALLY',365,'DAILY',1,'MONTHLY',30,'QUARTERLY',91,'WEEKLY',7)
551: INTO St_Billing_Cycle
552: FROM dual;
553: --dbms_output.put_line('B Cycle '||St_Billing_Cycle);
554: --dbms_output.put_line('B Offset '||St_Billing_Offset);
555: END;
556: */

Line 4062: DUAL;

4058: PA_PROJECT_FUNDINGS_S.NEXTVAL
4059: INTO
4060: St_Project_Funding_Id
4061: FROM
4062: DUAL;
4063: END ;
4064:
4065: BEGIN
4066: --Get Award Project Id for the Award of which this Agreement is part of

Line 4451: FROM DUAL

4447: IS
4448: CURSOR c_funding_exists
4449: IS
4450: SELECT 1
4451: FROM DUAL
4452: WHERE EXISTS (SELECT 1
4453: FROM pa_project_fundings
4454: WHERE agreement_id = p_agreement_id
4455: AND project_id = p_award_project_id);