APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on DUAL

Line 757: SELECT 'X' FROM DUAL

753: p_fee_id NUMBER
754: ) RETURN VARCHAR2 IS
755:
756: CURSOR C_Is_Exist_Assignment (X_Fee_Id NUMBER) IS
757: SELECT 'X' FROM DUAL
758: WHERE EXISTS ( SELECT NULL FROM LNS_FEE_ASSIGNMENTS
759: WHERE FEE_ID = X_FEE_ID )
760: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES
761: WHERE LINE_REFERENCE_ID = X_FEE_ID

Line 842: FROM DUAL

838:
839:
840: CURSOR loan_fee_exists ( c_loan_id NUMBER ) IS
841: SELECT 'Y'
842: FROM DUAL
843: WHERE
844: EXISTS
845: (SELECT NULL FROM LNS_FEE_ASSIGNMENTS LnsFeeAssignments
846: WHERE LnsFeeAssignments.LOAN_ID = c_loan_id)

Line 1095: FROM DUAL

1091:
1092:
1093: CURSOR l_fee_acct_line_exists ( c_loan_id NUMBER ) IS
1094: SELECT 'Y'
1095: FROM DUAL
1096: WHERE
1097: EXISTS
1098: (SELECT * FROM LNS_DISTRIBUTIONS lnsDistribs
1099: WHERE lnsDistribs.ACCOUNT_NAME = 'FEE_RECEIVABLE' AND lnsDistribs.LOAN_ID = c_loan_id);