[Home] [Help]
744: LnsLoanProductLines.MANDATORY_FLAG
745:
746: FROM LNS_CONDITIONS LnsConditions ,
747: LNS_LOAN_HEADERS LnsLoanHeaders ,
748: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
749:
750: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id
751: AND LnsLoanHeaders.PRODUCT_ID = LnsLoanProductLines.LOAN_PRODUCT_ID
752: AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'CONDITION'
768: l_cond_assignment_id NUMBER ;
769: l_loan_id NUMBER ;
770: l_condition_id NUMBER ;
771: l_cond_desc LNS_CONDITIONS.CONDITION_DESCRIPTION%TYPE ;
772: l_mandatory_flag LNS_LOAN_PRODUCT_LINES.MANDATORY_FLAG%TYPE ;
773: l_cond_assignment_rec cond_assignment_rec_type ;
774: x_return_status VARCHAR2(1) ;
775: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
776: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
907: LnsConditions.CONDITION_DESCRIPTION,
908: LnsLoanProductLines.MANDATORY_FLAG
909:
910: FROM LNS_CONDITIONS_VL LnsConditions ,
911: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
912:
913: WHERE LnsLoanProductLines.PARENT_PRODUCT_LINES_ID = c_loan_prod_line_id
914: AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'DISB_CONDITION'
915: AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsCOnditions.CONDITION_ID ;
916:
917: l_cond_assignment_id NUMBER ;
918: l_condition_id NUMBER ;
919: l_cond_desc LNS_CONDITIONS.CONDITION_DESCRIPTION%TYPE ;
920: l_mandatory_flag LNS_LOAN_PRODUCT_LINES.MANDATORY_FLAG%TYPE ;
921:
922: l_cond_assignment_rec cond_assignment_rec_type ;
923: x_return_status VARCHAR2(1) ;
924:
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
1076: AND ( LOAN_PRODUCT_LINE_TYPE = 'CONDITION' OR LOAN_PRODUCT_LINE_TYPE='DISB_CONDITION' )
1077: );
1078: