APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_DISTRIBUTIONS

Line 1097: from lns_distributions

1093: CURSOR prin_dr_dist_cur(P_LOAN_ID number) IS
1094: select CODE_COMBINATION_ID,
1095: DISTRIBUTION_PERCENT,
1096: USSGL_TRANSACTION_CODE
1097: from lns_distributions
1098: where LOAN_ID = P_LOAN_ID and
1099: account_type = 'DR' and
1100: account_name = 'PRINCIPAL_RECEIVABLE' and
1101: line_type = 'PRIN';

Line 1108: from lns_distributions

1104: CURSOR int_dr_dist_cur(P_LOAN_ID number) IS
1105: select CODE_COMBINATION_ID,
1106: DISTRIBUTION_PERCENT,
1107: USSGL_TRANSACTION_CODE
1108: from lns_distributions
1109: where LOAN_ID = P_LOAN_ID and
1110: account_type = 'DR' and
1111: account_name = 'INTEREST_RECEIVABLE' and
1112: line_type = 'INT' and

Line 1120: from lns_distributions

1116: CURSOR cur_fee_dr_dist(c_loan_id NUMBER, c_fee_id NUMBER, c_disb_hdr_id NUMBER) IS
1117: select CODE_COMBINATION_ID,
1118: DISTRIBUTION_PERCENT,
1119: USSGL_TRANSACTION_CODE
1120: from lns_distributions
1121: where LOAN_ID = c_loan_id and
1122: fee_id = c_fee_id and
1123: -- The below code criteria retrieves though the disb_header_id is null for fees, which are not disbFees
1124: nvl(disb_header_id, -1) = nvl(c_disb_hdr_id, -1) and

Line 1136: from lns_distributions

1132: CURSOR fee_dr_dist_cur(P_LOAN_ID number) IS
1133: select CODE_COMBINATION_ID,
1134: DISTRIBUTION_PERCENT,
1135: USSGL_TRANSACTION_CODE
1136: from lns_distributions
1137: where LOAN_ID = P_LOAN_ID and
1138: account_type = 'DR' and
1139: account_name = 'FEE_RECEIVABLE' and
1140: line_type = 'FEE';

Line 1147: from lns_distributions dist

1143: CURSOR prin_cr_dist_cur(P_LOAN_ID number, P_DATE date) IS
1144: select dist.CODE_COMBINATION_ID,
1145: sum(dist.DISTRIBUTION_PERCENT),
1146: dist.USSGL_TRANSACTION_CODE
1147: from lns_distributions dist
1148: where dist.LOAN_ID = P_LOAN_ID and
1149: dist.account_type = 'CR' and
1150: dist.account_name = 'LOAN_RECEIVABLE' and
1151: dist.line_type = 'PRIN' and

Line 1166: from lns_distributions

1162: CURSOR int_cr_dist_cur(P_LOAN_ID number) IS
1163: select CODE_COMBINATION_ID,
1164: DISTRIBUTION_PERCENT,
1165: USSGL_TRANSACTION_CODE
1166: from lns_distributions
1167: where LOAN_ID = P_LOAN_ID and
1168: account_type = 'CR' and
1169: account_name = 'INTEREST_INCOME' and
1170: line_type = 'INT' and

Line 1178: from lns_distributions

1174: CURSOR fee_cr_dist_cur(P_LOAN_ID number, P_FEE_ID number, C_DISB_HDR_ID number) IS
1175: select CODE_COMBINATION_ID,
1176: DISTRIBUTION_PERCENT,
1177: USSGL_TRANSACTION_CODE
1178: from lns_distributions
1179: where LOAN_ID = P_LOAN_ID and
1180: account_type = 'CR' and
1181: account_name = 'FEE_INCOME' and
1182: line_type = 'FEE' and