APPS.OZF_SD_BATCH_PVT dependencies on OZF_OFFERS

Line 12: -- OZF_OFFERS.TRANSACTION_CURRENCY_CODE

8: -- Author : MBHATT
9: -- Created : 11/16/2007 2:39:16 PM
10: -- History :
11: -- 16-FEB-2008 JMAHENDR - Modified GET_BATCH_CURRENCY_AMOUNT to use
12: -- OZF_OFFERS.TRANSACTION_CURRENCY_CODE
13: -- - Insert of claim_amount_currency_code in CREATE_BATCH_LINES
14: -- 22-FEB-2008 JMAHENDR - Change filter condition on batch line create to pick accruals that are !=0
15: -- - Change to use PO_VENDOR_CONTACTS instead of AP_SUPPLIER_CONTACTS
16: -- - Use of tradeprofile (TP) thresholds only if TP currency is set

Line 68: OZF_OFFERS.TRANSACTION_CURRENCY_CODE

64: FROM OZF_SD_BATCH_HEADERS_ALL
65: WHERE batch_id = p_batch_id;
66:
67: SELECT OZF_FUNDS_UTILIZED_ALL_B.PLAN_CURR_AMOUNT_REMAINING,
68: OZF_OFFERS.TRANSACTION_CURRENCY_CODE
69: INTO l_from_amount, l_from_currency
70: FROM OZF_FUNDS_UTILIZED_ALL_B, OZF_OFFERS
71: WHERE utilization_id = p_UTILIZATION_ID and
72: plan_id = OZF_OFFERS.QP_LIST_HEADER_ID;

Line 70: FROM OZF_FUNDS_UTILIZED_ALL_B, OZF_OFFERS

66:
67: SELECT OZF_FUNDS_UTILIZED_ALL_B.PLAN_CURR_AMOUNT_REMAINING,
68: OZF_OFFERS.TRANSACTION_CURRENCY_CODE
69: INTO l_from_amount, l_from_currency
70: FROM OZF_FUNDS_UTILIZED_ALL_B, OZF_OFFERS
71: WHERE utilization_id = p_UTILIZATION_ID and
72: plan_id = OZF_OFFERS.QP_LIST_HEADER_ID;
73: IF l_from_currency <> p_batch_currency then
74: OZF_UTILITY_PVT.Convert_Currency(x_return_status,

Line 72: plan_id = OZF_OFFERS.QP_LIST_HEADER_ID;

68: OZF_OFFERS.TRANSACTION_CURRENCY_CODE
69: INTO l_from_amount, l_from_currency
70: FROM OZF_FUNDS_UTILIZED_ALL_B, OZF_OFFERS
71: WHERE utilization_id = p_UTILIZATION_ID and
72: plan_id = OZF_OFFERS.QP_LIST_HEADER_ID;
73: IF l_from_currency <> p_batch_currency then
74: OZF_UTILITY_PVT.Convert_Currency(x_return_status,
75: l_from_currency,
76: p_batch_currency,

Line 1500: FND_DSQL.add_text('OZF_OFFERS OFRS ');

1496:
1497: FND_DSQL.add_text('HZ_CUST_SITE_USES_ALL HZCSU, ');
1498: FND_DSQL.add_text('HZ_CUST_ACCT_SITES_ALL HZCAS, ');
1499: FND_DSQL.add_text('HZ_CUST_ACCOUNTS HZCA, ');
1500: FND_DSQL.add_text('OZF_OFFERS OFRS ');
1501:
1502: --BEGIN WHERE CLAUSE
1503:
1504: FND_DSQL.add_text('WHERE RH.OFFER_ID = FU.PLAN_ID AND ');