APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on DUAL

Line 775: SELECT 'X' FROM DUAL

771: p_fee_id NUMBER
772: ) RETURN VARCHAR2 IS
773:
774: CURSOR C_Is_Exist_Assignment (X_Fee_Id NUMBER) IS
775: SELECT 'X' FROM DUAL
776: WHERE EXISTS ( SELECT NULL FROM LNS_FEE_ASSIGNMENTS
777: WHERE FEE_ID = X_FEE_ID )
778: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES
779: WHERE LINE_REFERENCE_ID = X_FEE_ID

Line 869: FROM DUAL

865:
866:
867: CURSOR loan_fee_exists ( c_loan_id NUMBER ) IS
868: SELECT 'Y'
869: FROM DUAL
870: WHERE
871: EXISTS
872: (SELECT NULL FROM LNS_FEE_ASSIGNMENTS LnsFeeAssignments
873: WHERE LnsFeeAssignments.LOAN_ID = c_loan_id)

Line 1138: FROM DUAL

1134:
1135:
1136: CURSOR l_fee_acct_line_exists ( c_loan_id NUMBER ) IS
1137: SELECT 'Y'
1138: FROM DUAL
1139: WHERE
1140: EXISTS
1141: (SELECT * FROM LNS_DISTRIBUTIONS lnsDistribs
1142: WHERE lnsDistribs.ACCOUNT_NAME = 'FEE_RECEIVABLE' AND lnsDistribs.LOAN_ID = c_loan_id);

Line 1431: SELECT 'X' FROM DUAL

1427: l_status lns_loan_headers_all.loan_status%TYPE;
1428: l_disb_status lns_disb_headers.status%TYPE;
1429:
1430: CURSOR c_fasgm_edit (c_loan_id NUMBER, c_fee_id NUMBER, c_disb_header_id NUMBER) IS
1431: SELECT 'X' FROM DUAL
1432: WHERE EXISTS ( SELECT NULL FROM LNS_FEE_ASSIGNMENTS fasgn
1433: WHERE (fasgn.LOAN_ID = c_loan_id
1434: OR (fasgn.DISB_HEADER_ID = c_disb_header_id ))
1435: AND fasgn.FEE_ID = c_fee_id