APPS.LNS_COND_ASSIGNMENT_PUB dependencies on LNS_LOAN_HEADERS

Line 747: LNS_LOAN_HEADERS LnsLoanHeaders ,

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
751: AND LnsLoanHeaders.PRODUCT_ID = LnsLoanProductLines.LOAN_PRODUCT_ID

Line 758: FROM LNS_LOAN_HEADERS LnsLoanHeaders

754:
755:
756: CURSOR current_loan_status ( c_loan_id NUMBER ) IS
757: SELECT LOAN_STATUS , CURRENT_PHASE
758: FROM LNS_LOAN_HEADERS LnsLoanHeaders
759: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id ;
760:
761:
762: CURSOR loan_cond_count ( c_loan_id NUMBER ) IS

Line 775: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;

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 ;
777: l_loan_cond_count NUMBER ;
778: is_commit_needed BOOLEAN;
779:

Line 776: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%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 ;
777: l_loan_cond_count NUMBER ;
778: is_commit_needed BOOLEAN;
779:
780: BEGIN