APPS.LNS_COND_ASSIGNMENT_PUB dependencies on DUAL

Line 1010: select LNS_COND_ASSIGNMENTS_S.NEXTVAL into l_temp_cond_assignment_id from DUAL;

1006:
1007: FETCH loan_prod_disb_cond INTO l_condition_id,l_cond_desc,l_mandatory_flag ;
1008: EXIT WHEN loan_prod_disb_cond%NOTFOUND ;
1009:
1010: select LNS_COND_ASSIGNMENTS_S.NEXTVAL into l_temp_cond_assignment_id from DUAL;
1011: l_cond_assignment_rec.COND_ASSIGNMENT_ID := l_temp_cond_assignment_id;
1012:
1013: --commented below line as it was throwing error PLS-00357 during the build by release team
1014: --l_cond_assignment_rec.COND_ASSIGNMENT_ID := LNS_COND_ASSIGNMENTS_S.NEXTVAL;

Line 1126: SELECT 'X' FROM DUAL

1122: p_condition_id NUMBER
1123: ) RETURN VARCHAR2 IS
1124:
1125: CURSOR C_Is_Exist_Assignment (X_COND_Id NUMBER) IS
1126: SELECT 'X' FROM DUAL
1127: WHERE EXISTS ( SELECT NULL FROM LNS_COND_ASSIGNMENTS
1128: WHERE CONDITION_ID = X_COND_ID )
1129: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES
1130: WHERE LINE_REFERENCE_ID = X_COND_ID