APPS.OZF_SD_UTIL_PVT dependencies on OZF_SD_BATCH_LINES_ALL

Line 29: select UTILIZATION_ID,CLAIM_AMOUNT_CURRENCY_CODE into l_util_id,l_from_currency from OZF_SD_BATCH_LINES_ALL where batch_line_id=p_batch_line_id;

25: l_util_id NUMBER;
26: x_return_status VARCHAR2(200);
27: begin
28:
29: select UTILIZATION_ID,CLAIM_AMOUNT_CURRENCY_CODE into l_util_id,l_from_currency from OZF_SD_BATCH_LINES_ALL where batch_line_id=p_batch_line_id;
30:
31: -- select currency_code into l_from_currency from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;
32:
33: select currency_code into l_to_currency from ozf_sd_batch_headers_all

Line 34: where batch_id=(select batch_id from ozf_sd_batch_lines_all

30:
31: -- select currency_code into l_from_currency from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;
32:
33: select currency_code into l_to_currency from ozf_sd_batch_headers_all
34: where batch_id=(select batch_id from ozf_sd_batch_lines_all
35: where batch_line_id = p_batch_line_id);
36:
37: select exchange_rate_date into l_conv_date from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;
38:

Line 66: from OZF_SD_BATCH_LINES_ALL

62: begin
63:
64: select UTILIZATION_ID ,claim_amount,acctd_amount_remaining,univ_curr_amount_remaining,amount_remaining
65: into l_util_id, l_claim_amount ,l_acctd_amount_remaining,l_univ_curr_amount_remaining,l_amount_remaining
66: from OZF_SD_BATCH_LINES_ALL
67: where batch_line_id=p_batch_line_id;
68:
69:
70:

Line 79: DELETE FROM OZF_SD_BATCH_LINES_ALL WHERE batch_line_id=p_batch_line_id;

75: univ_curr_amount_remaining=univ_curr_amount_remaining+l_amount_remaining
76:
77: WHERE UTILIZATION_ID=l_util_id;
78:
79: DELETE FROM OZF_SD_BATCH_LINES_ALL WHERE batch_line_id=p_batch_line_id;
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: x_meaning := NULL;
82:
83: