DBA Data[Home] [Help]

APPS.LNS_WORK_FLOW dependencies on FND_CURRENCY

Line 355: FND_CURRENCY.SAFE_GET_FORMAT_MASK(lh.LOAN_CURRENCY,50))

351: ,lh.loan_class_code
352: ,lh.loan_type_id
353: ,lt.loan_type_name
354: ,to_char(lh.requested_amount,
355: FND_CURRENCY.SAFE_GET_FORMAT_MASK(lh.LOAN_CURRENCY,50))
356: || ' ' || lh.loan_currency loan_formatted_amount
357: ,to_char(nvl(lh.requested_amount,0)-nvl(lh.funded_amount,0),
358: FND_CURRENCY.SAFE_GET_FORMAT_MASK(lh.LOAN_CURRENCY,50))
359: || ' ' || lh.loan_currency loan_undisbursed_amount

Line 358: FND_CURRENCY.SAFE_GET_FORMAT_MASK(lh.LOAN_CURRENCY,50))

354: ,to_char(lh.requested_amount,
355: FND_CURRENCY.SAFE_GET_FORMAT_MASK(lh.LOAN_CURRENCY,50))
356: || ' ' || lh.loan_currency loan_formatted_amount
357: ,to_char(nvl(lh.requested_amount,0)-nvl(lh.funded_amount,0),
358: FND_CURRENCY.SAFE_GET_FORMAT_MASK(lh.LOAN_CURRENCY,50))
359: || ' ' || lh.loan_currency loan_undisbursed_amount
360: ,decode(lh.loan_class_code,'ERS','LNS_ERS_CONTEXT_HOMEPAGE_MENU',
361: 'LNS_LOAN_CONTEXT_HOMEPAGE_MENU') function_name
362: ,lh.last_updated_by current_user_id

Line 772: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))

768: (CASE WHEN llh.loan_status in ('INCOMPLETE','REJECTED','DELETED','PENDING','APPROVED','IN_FUNDING','FUNDING_ERROR','CANCELLED') OR llh.FUNDED_AMOUNT = 0 THEN llh.requested_amount
769: ELSE ps.total_principal_balance END) loan_amount
770: ,to_char((CASE WHEN llh.loan_status in ('INCOMPLETE','REJECTED','DELETED','PENDING','APPROVED','IN_FUNDING','FUNDING_ERROR','CANCELLED') OR llh.FUNDED_AMOUNT = 0 THEN llh.requested_amount
771: ELSE ps.total_principal_balance END),
772: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
773: || ' ' || llh.loan_currency loan_formatted_amount
774: FROM lns_loan_headers_all llh
775: ,lns_pay_sum_v ps
776: WHERE llh.loan_id = p_loan_id

Line 780: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))

776: WHERE llh.loan_id = p_loan_id
777: AND ps.loan_id = llh.loan_id;
778: CURSOR csr_loan_details2 IS
779: SELECT to_char(ps.total_overdue,
780: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
781: || ' ' || llh.loan_currency overdue_amount
782: ,ps.number_overdue_bills overdue_num
783: FROM lns_loan_headers_all llh
784: ,lns_pay_sum_overdue_v ps