APPS.LNS_COND_ASSIGNMENT_PUB dependencies on LNS_CONDITIONS

Line 746: FROM LNS_CONDITIONS LnsConditions ,

742: LnsConditions.CONDITION_ID,
743: LnsConditions.CONDITION_DESCRIPTION,
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

Line 771: l_cond_desc LNS_CONDITIONS.CONDITION_DESCRIPTION%TYPE ;

767:
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 ;

Line 910: FROM LNS_CONDITIONS_VL LnsConditions ,

906: LnsConditions.CONDITION_ID,
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'

Line 919: l_cond_desc LNS_CONDITIONS.CONDITION_DESCRIPTION%TYPE ;

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) ;