DBA Data[Home] [Help]

APPS.LNS_WORK_FLOW dependencies on FND_CURRENCY

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

584: ,lh.loan_class_code
585: ,lh.loan_type_id
586: ,lt.loan_type_name
587: ,to_char(lh.requested_amount,
588: FND_CURRENCY.SAFE_GET_FORMAT_MASK(lh.LOAN_CURRENCY,50))
589: || ' ' || lh.loan_currency loan_formatted_amount
590: ,to_char(nvl(lh.requested_amount,0)-nvl(lh.funded_amount,0),
591: FND_CURRENCY.SAFE_GET_FORMAT_MASK(lh.LOAN_CURRENCY,50))
592: || ' ' || lh.loan_currency loan_undisbursed_amount

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

587: ,to_char(lh.requested_amount,
588: FND_CURRENCY.SAFE_GET_FORMAT_MASK(lh.LOAN_CURRENCY,50))
589: || ' ' || lh.loan_currency loan_formatted_amount
590: ,to_char(nvl(lh.requested_amount,0)-nvl(lh.funded_amount,0),
591: FND_CURRENCY.SAFE_GET_FORMAT_MASK(lh.LOAN_CURRENCY,50))
592: || ' ' || lh.loan_currency loan_undisbursed_amount
593: ,decode(lh.loan_class_code,'ERS','LNS_ERS_CONTEXT_HOMEPAGE_MENU',
594: 'LNS_LOAN_CONTEXT_HOMEPAGE_MENU') function_name
595: ,lh.last_updated_by current_user_id

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

1066: (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
1067: ELSE ps.total_principal_balance END) loan_amount
1068: ,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
1069: ELSE ps.total_principal_balance END),
1070: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
1071: || ' ' || llh.loan_currency loan_formatted_amount
1072: FROM lns_loan_headers_all llh
1073: ,lns_pay_sum_v ps
1074: WHERE llh.loan_id = p_loan_id

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

1075: AND ps.loan_id = llh.loan_id;
1076:
1077: CURSOR csr_loan_details2 IS
1078: SELECT to_char(ps.total_overdue,
1079: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
1080: || ' ' || llh.loan_currency overdue_amount
1081: ,ps.number_overdue_bills overdue_num
1082: FROM lns_loan_headers_all llh
1083: ,lns_pay_sum_overdue_v ps