APPS.LNS_APPL_ENGINE_PUB dependencies on AR_CASH_RECEIPTS

Line 199: select receipt_number from ar_cash_receipts where cash_receipt_id = P_RECEIPT_ID;

195: select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = P_UNAPPLY_FLAG;
196:
197: /* query for flag meaning */
198: CURSOR receipt_cur(P_RECEIPT_ID number) IS
199: select receipt_number from ar_cash_receipts where cash_receipt_id = P_RECEIPT_ID;
200:
201: /* query for flag meaning */
202: CURSOR receipt_match_cur(P_RECEIPT_MATCH_CRITERIA varchar2) IS
203: select meaning from FND_LOOKUP_VALUES where lookup_type = 'LNS_RECEIPT_MATCH_CRITERIA' and lookup_code = P_RECEIPT_MATCH_CRITERIA;

Line 1333: ar_cash_receipts cr

1329: lns_system_options sys,
1330: gl_sets_of_books books,
1331: hz_parties party,
1332: AR_SYSTEM_PARAMETERS arsys,
1333: ar_cash_receipts cr
1334: where
1335: loan.loan_id = :1 and
1336: loan.loan_id = par.loan_id and
1337: (par.loan_participant_type = ''PRIMARY_BORROWER'' or

Line 2131: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '<<--------Applying AR cash receipts to loan invoices...-------->>');

2127:
2128: g_cr_return_status := 'NORMAL';
2129:
2130: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');
2131: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '<<--------Applying AR cash receipts to loan invoices...-------->>');
2132:
2133: l_SEARCH_REC.LOAN_BORROWER_ID := LOAN_BORROWER_ID;
2134: l_SEARCH_REC.LOAN_PRODUCT_ID := LOAN_PRODUCT_ID;
2135: l_SEARCH_REC.LOAN_ID := LOAN_ID;