DBA Data[Home] [Help]

APPS.LNS_COND_ASSIGNMENT_PUB dependencies on DUAL

Line 1071: SELECT 'X' FROM DUAL

1067: p_condition_id NUMBER
1068: ) RETURN VARCHAR2 IS
1069:
1070: CURSOR C_Is_Exist_Assignment (X_COND_Id NUMBER) IS
1071: SELECT 'X' FROM DUAL
1072: WHERE EXISTS ( SELECT NULL FROM LNS_COND_ASSIGNMENTS
1073: WHERE CONDITION_ID = X_COND_ID )
1074: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES
1075: WHERE LINE_REFERENCE_ID = X_COND_ID