eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_LOAN_HEADERS

Line 847: LNS_LOAN_HEADERS LnsLoanHeaders ,

843: NULL OPEN_PHASE_FLAG, -- We don't use this flag anywhere
844: NULL PHASE,
845: LnsFees.CUSTOM_PROCEDURE
846: FROM LNS_FEES LnsFees ,
847: LNS_LOAN_HEADERS LnsLoanHeaders ,
848: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
849:
850: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id
851: AND LnsLoanHeaders.PRODUCT_ID = LnsLoanProductLines.LOAN_PRODUCT_ID

Line 863: FROM LNS_LOAN_HEADERS LnsLoanHeaders

859:
860:
861: CURSOR current_loan_status ( c_loan_id NUMBER ) IS
862: SELECT LOAN_STATUS , CURRENT_PHASE
863: FROM LNS_LOAN_HEADERS LnsLoanHeaders
864: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id ;
865:
866:
867: CURSOR loan_fee_exists ( c_loan_id NUMBER ) IS

Line 883: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;

879:
880: l_fee_assignment_rec fee_assignment_rec_type ;
881: l_fee_assignment_id NUMBER ;
882: x_return_status VARCHAR2(1) ;
883: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
884: l_loan_Current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
885: l_loan_fee_exists VARCHAR2(1) ;
886:
887: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;

Line 884: l_loan_Current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;

880: l_fee_assignment_rec fee_assignment_rec_type ;
881: l_fee_assignment_id NUMBER ;
882: x_return_status VARCHAR2(1) ;
883: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
884: l_loan_Current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
885: l_loan_fee_exists VARCHAR2(1) ;
886:
887: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
888: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;

Line 1132: FROM LNS_LOAN_HEADERS LnsLoanHeaders

1128:
1129:
1130: CURSOR current_loan_status ( c_loan_id NUMBER ) IS
1131: SELECT LOAN_STATUS , CURRENT_PHASE
1132: FROM LNS_LOAN_HEADERS LnsLoanHeaders
1133: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id ;
1134:
1135:
1136: CURSOR l_fee_acct_line_exists ( c_loan_id NUMBER ) IS

Line 1148: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;

1144:
1145: l_fee_assignment_rec fee_assignment_rec_type ;
1146: l_fee_assignment_id NUMBER ;
1147: x_return_status VARCHAR2(1) ;
1148: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
1149: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
1150: l_loan_fee_acct_line_exists VARCHAR2(1);
1151:
1152: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;

Line 1149: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;

1145: l_fee_assignment_rec fee_assignment_rec_type ;
1146: l_fee_assignment_id NUMBER ;
1147: x_return_status VARCHAR2(1) ;
1148: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
1149: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
1150: l_loan_fee_acct_line_exists VARCHAR2(1);
1151:
1152: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
1153: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;

Line 1427: l_status lns_loan_headers_all.loan_status%TYPE;

1423:
1424: l_updatableFlag VARCHAR2(1);
1425: l_fees_category lns_fees_all.fee_category%TYPE;
1426: l_fee_type lns_fees_all.fee_type%TYPE;
1427: l_status lns_loan_headers_all.loan_status%TYPE;
1428: l_disb_status lns_disb_headers.status%TYPE;
1429:
1430: CURSOR c_fasgm_edit (c_loan_id NUMBER, c_fee_id NUMBER, c_disb_header_id NUMBER) IS
1431: SELECT 'X' FROM DUAL

Line 1480: lns_loan_headers_all hdr

1476: CURSOR c_loan_details (c_disb_header_id NUMBER) IS
1477: SELECT
1478: hdr.loan_status
1479: FROM
1480: lns_loan_headers_all hdr
1481: WHERE
1482: hdr.loan_id in (select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id);
1483:
1484: CURSOR c_disb_details (c_disb_header_id NUMBER) IS