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.

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_DEFAULT_DISTRIBS

Line 857: FROM LNS_DEFAULT_DISTRIBS

853: AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsFees.FEE_ID ;
854:
855: CURSOR fee_account_lines ( c_fee_id NUMBER ) IS
856: SELECT LINE_TYPE, ACCOUNT_NAME, CODE_COMBINATION_ID, ACCOUNT_TYPE, DISTRIBUTION_PERCENT, DISTRIBUTION_TYPE
857: FROM LNS_DEFAULT_DISTRIBS
858: WHERE ACCOUNT_NAME = 'FEE_RECEIVABLE' OR FEE_ID = c_fee_id ;
859:
860:
861: CURSOR current_loan_status ( c_loan_id NUMBER ) IS

Line 887: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;

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 ;
889: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
890: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
891: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;

Line 888: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%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 ;
889: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
890: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
891: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
892: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;

Line 889: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%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 ;
889: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
890: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
891: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
892: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
893:

Line 890: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;

886:
887: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
888: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
889: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
890: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
891: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
892: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
893:
894: is_commit_needed BOOLEAN;

Line 891: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;

887: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
888: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
889: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
890: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
891: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
892: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
893:
894: is_commit_needed BOOLEAN;
895: l_msg_count NUMBER;

Line 892: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;

888: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
889: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
890: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
891: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
892: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
893:
894: is_commit_needed BOOLEAN;
895: l_msg_count NUMBER;
896: l_msg_data VARCHAR2(32767);

Line 1126: FROM LNS_DEFAULT_DISTRIBS

1122: AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsFees.FEE_ID ;
1123:
1124: CURSOR fee_account_lines ( c_fee_id NUMBER ) IS
1125: SELECT LINE_TYPE, ACCOUNT_NAME, CODE_COMBINATION_ID, ACCOUNT_TYPE, DISTRIBUTION_PERCENT, DISTRIBUTION_TYPE
1126: FROM LNS_DEFAULT_DISTRIBS
1127: WHERE ACCOUNT_NAME = 'FEE_RECEIVABLE' OR FEE_ID = c_fee_id ;
1128:
1129:
1130: CURSOR current_loan_status ( c_loan_id NUMBER ) IS

Line 1152: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;

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 ;
1154: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
1155: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
1156: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;

Line 1153: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%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 ;
1154: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
1155: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
1156: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
1157: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;

Line 1154: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%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 ;
1154: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
1155: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
1156: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
1157: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
1158:

Line 1155: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;

1151:
1152: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
1153: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
1154: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
1155: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
1156: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
1157: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
1158:
1159: is_commit_needed BOOLEAN;

Line 1156: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;

1152: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
1153: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
1154: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
1155: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
1156: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
1157: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
1158:
1159: is_commit_needed BOOLEAN;
1160: l_msg_count NUMBER;

Line 1157: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;

1153: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;
1154: l_code_combination_id LNS_DEFAULT_DISTRIBS.CODE_COMBINATION_ID%TYPE ;
1155: l_account_type LNS_DEFAULT_DISTRIBS.ACCOUNT_TYPE%TYPE ;
1156: l_distribution_percent LNS_DEFAULT_DISTRIBS.DISTRIBUTION_PERCENT%TYPE ;
1157: l_distribution_type LNS_DEFAULT_DISTRIBS.DISTRIBUTION_TYPE%TYPE ;
1158:
1159: is_commit_needed BOOLEAN;
1160: l_msg_count NUMBER;
1161: l_msg_data VARCHAR2(32767);