APPS.OZF_SD_UTIL_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 32: -- select currency_code into l_from_currency from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;

28: begin
29:
30: 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;
31:
32: -- select currency_code into l_from_currency from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;
33:
34: select currency_code into l_to_currency from ozf_sd_batch_headers_all
35: where batch_id=(select batch_id from ozf_sd_batch_lines_all
36: where batch_line_id = p_batch_line_id);

Line 38: -- select exchange_rate_date into l_conv_date from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;

34: select currency_code into l_to_currency from ozf_sd_batch_headers_all
35: where batch_id=(select batch_id from ozf_sd_batch_lines_all
36: where batch_line_id = p_batch_line_id);
37:
38: -- select exchange_rate_date into l_conv_date from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;
39:
40: OZF_UTILITY_PVT.Convert_Currency (
41: x_return_status ,
42: l_from_currency ,

Line 166: UPDATE OZF_FUNDS_UTILIZED_ALL_B

162: where batch_line_id=p_batch_line_id;
163:
164:
165:
166: UPDATE OZF_FUNDS_UTILIZED_ALL_B
167: SET amount_remaining=amount_remaining+l_amount_remaining,
168: PLAN_CURR_AMOUNT_REMAINING=PLAN_CURR_AMOUNT_REMAINING+l_claim_amount,
169: acctd_amount_remaining=acctd_amount_remaining+l_acctd_amount_remaining,
170: univ_curr_amount_remaining=univ_curr_amount_remaining+l_amount_remaining,

Line 1180: ozf_funds_utilized_all_b util,

1176: util.plan_type,
1177: util.plan_id,
1178: util.exchange_rate_date
1179: FROM OZF_SD_BATCH_LINES_ALL lines ,
1180: ozf_funds_utilized_all_b util,
1181: ozf_claim_types_all_vl adj
1182:
1183: WHERE lines.batch_id = p_batch_header_id
1184: AND (lines.status_code = 'APPROVED'

Line 1280: UPDATE ozf_funds_utilized_all_b

1276:
1277:
1278: ELSE
1279:
1280: UPDATE ozf_funds_utilized_all_b
1281: SET amount_remaining = 0,
1282: acctd_amount_remaining = 0,
1283: plan_curr_amount_remaining = 0,
1284: univ_curr_amount_remaining = 0