APPS.LNS_COND_ASSIGNMENT_PUB dependencies on LNS_LOAN_HEADERS

Line 798: LNS_LOAN_HEADERS LnsLoanHeaders ,

794: LnsConditions.CONDITION_DESCRIPTION,
795: LnsLoanProductLines.MANDATORY_FLAG
796:
797: FROM LNS_CONDITIONS LnsConditions ,
798: LNS_LOAN_HEADERS LnsLoanHeaders ,
799: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
800:
801: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id
802: AND LnsLoanHeaders.PRODUCT_ID = LnsLoanProductLines.LOAN_PRODUCT_ID

Line 809: FROM LNS_LOAN_HEADERS LnsLoanHeaders

805:
806:
807: CURSOR current_loan_status ( c_loan_id NUMBER ) IS
808: SELECT LOAN_STATUS , CURRENT_PHASE
809: FROM LNS_LOAN_HEADERS LnsLoanHeaders
810: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id ;
811:
812:
813: CURSOR loan_cond_count ( c_loan_id NUMBER ) IS

Line 826: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;

822: l_cond_desc LNS_CONDITIONS.CONDITION_DESCRIPTION%TYPE ;
823: l_mandatory_flag LNS_LOAN_PRODUCT_LINES.MANDATORY_FLAG%TYPE ;
824: l_cond_assignment_rec cond_assignment_rec_type ;
825: x_return_status VARCHAR2(1) ;
826: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
827: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
828: l_loan_cond_count NUMBER ;
829: is_commit_needed BOOLEAN;
830:

Line 827: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;

823: l_mandatory_flag LNS_LOAN_PRODUCT_LINES.MANDATORY_FLAG%TYPE ;
824: l_cond_assignment_rec cond_assignment_rec_type ;
825: x_return_status VARCHAR2(1) ;
826: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
827: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
828: l_loan_cond_count NUMBER ;
829: is_commit_needed BOOLEAN;
830:
831: BEGIN