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_LOAN_PUB dependencies on LNS_DEFAULT_DISTRIBS

Line 2548: FROM LNS_DEFAULT_DISTRIBS

2544: AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsFees.FEE_ID ;
2545:
2546: CURSOR fee_account_lines ( c_fee_id NUMBER ) IS
2547: SELECT LINE_TYPE, ACCOUNT_NAME, CODE_COMBINATION_ID, ACCOUNT_TYPE, DISTRIBUTION_PERCENT, DISTRIBUTION_TYPE
2548: FROM LNS_DEFAULT_DISTRIBS
2549: WHERE ACCOUNT_NAME = 'FEE_RECEIVABLE' OR FEE_ID = c_fee_id ;
2550:
2551: CURSOR current_loan_status ( c_loan_id NUMBER ) IS
2552: SELECT LOAN_STATUS , CURRENT_PHASE

Line 2574: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;

2570: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
2571: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
2572: l_loan_fee_exists VARCHAR2(1) ;
2573:
2574: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
2575: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
2576: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
2577: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
2578: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;

Line 2575: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;

2571: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
2572: l_loan_fee_exists VARCHAR2(1) ;
2573:
2574: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
2575: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
2576: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
2577: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
2578: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
2579: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;

Line 2576: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;

2572: l_loan_fee_exists VARCHAR2(1) ;
2573:
2574: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
2575: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
2576: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
2577: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
2578: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
2579: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
2580:

Line 2577: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;

2573:
2574: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
2575: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
2576: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
2577: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
2578: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
2579: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
2580:
2581: l_return_status VARCHAR2(1) ;

Line 2578: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;

2574: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
2575: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
2576: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
2577: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
2578: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
2579: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
2580:
2581: l_return_status VARCHAR2(1) ;
2582: l_msg_count NUMBER;

Line 2579: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;

2575: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
2576: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
2577: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
2578: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
2579: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
2580:
2581: l_return_status VARCHAR2(1) ;
2582: l_msg_count NUMBER;
2583: l_msg_data VARCHAR2(32767);