APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_LOAN_HEADERS

Line 820: LNS_LOAN_HEADERS LnsLoanHeaders ,

816: NULL DISB_HEADER_ID,
817: LnsLoanProductLines.MANDATORY_FLAG
818:
819: FROM LNS_FEES LnsFees ,
820: LNS_LOAN_HEADERS LnsLoanHeaders ,
821: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
822:
823: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id
824: AND LnsLoanHeaders.PRODUCT_ID = LnsLoanProductLines.LOAN_PRODUCT_ID

Line 836: FROM LNS_LOAN_HEADERS LnsLoanHeaders

832:
833:
834: CURSOR current_loan_status ( c_loan_id NUMBER ) IS
835: SELECT LOAN_STATUS , CURRENT_PHASE
836: FROM LNS_LOAN_HEADERS LnsLoanHeaders
837: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id ;
838:
839:
840: CURSOR loan_fee_exists ( c_loan_id NUMBER ) IS

Line 856: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;

852:
853: l_fee_assignment_rec fee_assignment_rec_type ;
854: l_fee_assignment_id NUMBER ;
855: x_return_status VARCHAR2(1) ;
856: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
857: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
858: l_loan_fee_exists VARCHAR2(1) ;
859:
860: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;

Line 857: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;

853: l_fee_assignment_rec fee_assignment_rec_type ;
854: l_fee_assignment_id NUMBER ;
855: x_return_status VARCHAR2(1) ;
856: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
857: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
858: l_loan_fee_exists VARCHAR2(1) ;
859:
860: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
861: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;

Line 1089: FROM LNS_LOAN_HEADERS LnsLoanHeaders

1085:
1086:
1087: CURSOR current_loan_status ( c_loan_id NUMBER ) IS
1088: SELECT LOAN_STATUS , CURRENT_PHASE
1089: FROM LNS_LOAN_HEADERS LnsLoanHeaders
1090: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id ;
1091:
1092:
1093: CURSOR l_fee_acct_line_exists ( c_loan_id NUMBER ) IS

Line 1105: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;

1101:
1102: l_fee_assignment_rec fee_assignment_rec_type ;
1103: l_fee_assignment_id NUMBER ;
1104: x_return_status VARCHAR2(1) ;
1105: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
1106: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
1107: l_loan_fee_acct_line_exists VARCHAR2(1);
1108:
1109: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;

Line 1106: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;

1102: l_fee_assignment_rec fee_assignment_rec_type ;
1103: l_fee_assignment_id NUMBER ;
1104: x_return_status VARCHAR2(1) ;
1105: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
1106: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
1107: l_loan_fee_acct_line_exists VARCHAR2(1);
1108:
1109: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
1110: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;