APPS.OZF_SD_BATCH_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 67: SELECT OZF_FUNDS_UTILIZED_ALL_B.PLAN_CURR_AMOUNT_REMAINING,

63: INTO l_conv_date
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

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 1491: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');

1487: FND_DSQL.add_text('FU.AMOUNT_REMAINING, ');
1488: FND_DSQL.add_text('RL.ORG_ID '); -- Inventory Org ID
1489:
1490: --BEGIN FROM CLAUSE
1491: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');
1492: FND_DSQL.add_text('OE_ORDER_HEADERS_ALL OEH, ');
1493: FND_DSQL.add_text('OE_ORDER_LINES_ALL OEL, ');
1494: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');
1495: FND_DSQL.add_text('OZF_SD_REQUEST_LINES_ALL RL , ');

Line 2043: UPDATE ozf_funds_utilized_all_b

2039: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_id = ' || p_batch_id);
2040: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_threshold = ' || p_batch_threshold);
2041: END IF;
2042:
2043: UPDATE ozf_funds_utilized_all_b
2044: SET amount_remaining = 0,
2045: acctd_amount_remaining = 0,
2046: plan_curr_amount_remaining = 0,
2047: univ_curr_amount_remaining = 0,