DBA Data[Home] [Help]

APPS.GL_CONSOLIDATION_PKG dependencies on DUAL

Line 375: FROM DUAL

371: PROCEDURE Check_Mapping_Used_In_Sets( X_Consolidation_Id NUMBER,
372: X_Mapping_Used_In_Set IN OUT NOCOPY VARCHAR2) IS
373: CURSOR C4 IS
374: SELECT 'Y'
375: FROM DUAL
376: WHERE EXISTS
377: ( SELECT 'Mapping found in a mapping set'
378: FROM GL_CONS_SET_ASSIGNMENTS ASG
379: WHERE ASG.consolidation_id = X_Consolidation_Id

Line 399: FROM DUAL

395: PROCEDURE Check_Mapping_Run( X_Consolidation_Id NUMBER,
396: X_Mapping_Has_Been_Run IN OUT NOCOPY VARCHAR2) IS
397: CURSOR C4 IS
398: SELECT 'Y'
399: FROM DUAL
400: WHERE EXISTS
401: ( SELECT 'Mapping has been run atleast once'
402: FROM GL_CONSOLIDATION_HISTORY COH
403: WHERE COH.consolidation_id = X_Consolidation_Id