APPS.PA_PWP_NOTIFICATION dependencies on FND_CURRENCY

Line 36: ,to_char(NVL(ra.amount_applied_from,ra.amount_applied),fnd_currency.get_format_mask(rcr.currency_code, 20)) amount_applied

32:
33: CURSOR c_inv_info ( l_receivable_application_id NUMBER )
34: IS
35: SELECT RA.CASH_RECEIPT_ID Receipt_id
36: ,to_char(NVL(ra.amount_applied_from,ra.amount_applied),fnd_currency.get_format_mask(rcr.currency_code, 20)) amount_applied
37: ,RCR.RECEIPT_NUMBER Receipt_number
38: ,RCR.RECEIPT_DATE Receipt_Date
39: ,to_char(NVL(rcr.amount,0),fnd_currency.get_format_mask(rcr.currency_code, 20)) receipt_amount
40: ,RCR.CURRENCY_CODE Receipt_Currency_Code

Line 39: ,to_char(NVL(rcr.amount,0),fnd_currency.get_format_mask(rcr.currency_code, 20)) receipt_amount

35: SELECT RA.CASH_RECEIPT_ID Receipt_id
36: ,to_char(NVL(ra.amount_applied_from,ra.amount_applied),fnd_currency.get_format_mask(rcr.currency_code, 20)) amount_applied
37: ,RCR.RECEIPT_NUMBER Receipt_number
38: ,RCR.RECEIPT_DATE Receipt_Date
39: ,to_char(NVL(rcr.amount,0),fnd_currency.get_format_mask(rcr.currency_code, 20)) receipt_amount
40: ,RCR.CURRENCY_CODE Receipt_Currency_Code
41: ,RA.receivable_application_id RA_ID
42: ,pdi.ra_invoice_number AR_Invoice_No
43: ,to_char(NVL(rpsa.amount_due_original, 0), fnd_currency.get_format_mask(rpsa.invoice_currency_code, 20)) ar_invoice_amount

Line 43: ,to_char(NVL(rpsa.amount_due_original, 0), fnd_currency.get_format_mask(rpsa.invoice_currency_code, 20)) ar_invoice_amount

39: ,to_char(NVL(rcr.amount,0),fnd_currency.get_format_mask(rcr.currency_code, 20)) receipt_amount
40: ,RCR.CURRENCY_CODE Receipt_Currency_Code
41: ,RA.receivable_application_id RA_ID
42: ,pdi.ra_invoice_number AR_Invoice_No
43: ,to_char(NVL(rpsa.amount_due_original, 0), fnd_currency.get_format_mask(rpsa.invoice_currency_code, 20)) ar_invoice_amount
44: ,trunc(RPSA.TRX_DATE) AR_Invoice_Date
45: ,RPSA.INVOICE_CURRENCY_CODE AR_Invoice_Currency_Code
46: ,RCTRX.interface_header_attribute1 Project_Number
47: ,trunc(sysdate) Date_of_notification