[Home] [Help]
1432: AND third_party_id = ln_customer_id --variable: ln_customer_id
1433: AND account_segment = lv_account_number --variable: lv_account_number
1434: AND period_name = pv_first_period --parameter: pv_first_period
1435: GROUP BY third_party_id, currency_code) bal,
1436: Fnd_Currencies_Vl Fcv
1437: WHERE bal.Functional_Amount <> 0
1438: AND Fcv.currency_code = bal.currency_code
1439: ORDER BY bal.currency_code;
1440:
1516:
1517: BEGIN
1518: SELECT Fcv.NAME Functional_Currency
1519: INTO lv_fun_currency
1520: FROM Gl_Ledgers Gl, Fnd_Currencies_Vl Fcv
1521: WHERE Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1522: AND Fcv.CURRENCY_CODE = Gl.Currency_Code;
1523: EXCEPTION
1524: WHEN NO_DATA_FOUND THEN
1653: ln_row_count NUMBER := 0;
1654: ld_start_date DATE;
1655: ld_end_date DATE;
1656: lv_balance_side FND_LOOKUP_VALUES.MEANING%TYPE;
1657: lv_functional_currency fnd_currencies_vl.NAME%TYPE;
1658:
1659: ln_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
1660: lr_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
1661: lv_attribute_column4bill_num ja_cn_dff_assignments.attribute_column%TYPE;
1927: Gl_Import_References Gir,
1928: Gl_Je_Headers Jeh,
1929: Gl_Ledgers Gl,
1930: Gl_Periods Gp,
1931: fnd_currencies_vl Fcv
1932: WHERE Rct.customer_trx_id = ln_customer_trx_id --variable: ln_customer_trx_id
1933: AND Rct.CUSTOMER_TRX_ID = Rctlgd.CUSTOMER_TRX_ID
1934: AND Rctlgd.ACCOUNT_CLASS = 'REC'
1935: AND Rctlgd.LATEST_REC_FLAG = 'Y'
1989: Gl_Je_Headers Jeh,
1990: Gl_Import_References Gir,
1991: Gl_Ledgers Gl,
1992: Gl_Periods Gp,
1993: fnd_currencies_vl Fcv
1994: WHERE Acr.Cash_Receipt_Id = App.Cash_Receipt_Id
1995: AND App.Applied_Customer_Trx_Id = ln_customer_trx_id -- variable: ln_customer_trx_id
1996: --SLA condition
1997: AND Ent.Application_Id = 222
2118: Gl_Import_References Gir,
2119: Gl_Je_Headers Jeh,
2120: Gl_Ledgers Gl,
2121: Gl_Periods Gp,
2122: fnd_currencies_vl fcv
2123: WHERE Rct.Previous_Customer_Trx_Id = ln_customer_trx_id -- variable: ln_customer_trx_id
2124: AND Rct.CUSTOMER_TRX_ID = Rctlgd.CUSTOMER_TRX_ID
2125: AND Rctlgd.ACCOUNT_CLASS = 'REC'
2126: AND Rctlgd.LATEST_REC_FLAG = 'Y'
2552: '.variable:' ||
2553: 'ln_flex_value_set_id=' || ln_flex_value_set_id);*/
2554:
2555: --Fetch functional currency
2556: SELECT fnd_currencies_vl.NAME
2557: INTO lv_functional_currency
2558: FROM fnd_currencies_vl
2559: WHERE currency_code =
2560: (SELECT currency_code
2554:
2555: --Fetch functional currency
2556: SELECT fnd_currencies_vl.NAME
2557: INTO lv_functional_currency
2558: FROM fnd_currencies_vl
2559: WHERE currency_code =
2560: (SELECT currency_code
2561: FROM gl_ledgers
2562: WHERE ledger_id = pn_ledger_id);