APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_DISTRIBUTIONS

Line 1081: from lns_distributions

1077: CURSOR prin_dr_dist_cur(P_LOAN_ID number) IS
1078: select CODE_COMBINATION_ID,
1079: DISTRIBUTION_PERCENT,
1080: USSGL_TRANSACTION_CODE
1081: from lns_distributions
1082: where LOAN_ID = P_LOAN_ID and
1083: account_type = 'DR' and
1084: account_name = 'PRINCIPAL_RECEIVABLE' and
1085: line_type = 'PRIN';

Line 1092: from lns_distributions

1088: CURSOR int_dr_dist_cur(P_LOAN_ID number) IS
1089: select CODE_COMBINATION_ID,
1090: DISTRIBUTION_PERCENT,
1091: USSGL_TRANSACTION_CODE
1092: from lns_distributions
1093: where LOAN_ID = P_LOAN_ID and
1094: account_type = 'DR' and
1095: account_name = 'INTEREST_RECEIVABLE' and
1096: line_type = 'INT';

Line 1103: from lns_distributions

1099: CURSOR fee_dr_dist_cur(P_LOAN_ID number) IS
1100: select CODE_COMBINATION_ID,
1101: DISTRIBUTION_PERCENT,
1102: USSGL_TRANSACTION_CODE
1103: from lns_distributions
1104: where LOAN_ID = P_LOAN_ID and
1105: account_type = 'DR' and
1106: account_name = 'FEE_RECEIVABLE' and
1107: line_type = 'FEE';

Line 1114: from lns_distributions

1110: CURSOR prin_cr_dist_cur(P_LOAN_ID number) IS
1111: select CODE_COMBINATION_ID,
1112: DISTRIBUTION_PERCENT,
1113: USSGL_TRANSACTION_CODE
1114: from lns_distributions
1115: where LOAN_ID = P_LOAN_ID and
1116: account_type = 'CR' and
1117: account_name = 'LOAN_RECEIVABLE' and
1118: line_type = 'PRIN';

Line 1125: from lns_distributions

1121: CURSOR int_cr_dist_cur(P_LOAN_ID number) IS
1122: select CODE_COMBINATION_ID,
1123: DISTRIBUTION_PERCENT,
1124: USSGL_TRANSACTION_CODE
1125: from lns_distributions
1126: where LOAN_ID = P_LOAN_ID and
1127: account_type = 'CR' and
1128: account_name = 'INTEREST_INCOME' and
1129: line_type = 'INT';

Line 1136: from lns_distributions

1132: CURSOR fee_cr_dist_cur(P_LOAN_ID number, P_FEE_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 = 'CR' and
1139: account_name = 'FEE_INCOME' and
1140: line_type = 'FEE' and