APPS.OZF_SD_BATCH_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 1909: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');

1905: FND_DSQL.add_text('FU.PLAN_CURRENCY_CODE, ');
1906: FND_DSQL.add_text('ospa.SSD_DEC_ADJ_TYPE_ID ');
1907:
1908: --BEGIN FROM CLAUSE
1909: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');
1910: FND_DSQL.add_text('OE_ORDER_HEADERS_ALL OEH, ');
1911: FND_DSQL.add_text('OE_ORDER_LINES_ALL OEL, ');
1912: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');
1913: FND_DSQL.add_text('HZ_CUST_SITE_USES_ALL HZCSU, ');

Line 2767: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');

2763: FND_DSQL.add_text('FU.PLAN_CURRENCY_CODE, '); --approved discount currency
2764: FND_DSQL.add_text('ospa.SSD_DEC_ADJ_TYPE_ID ');
2765:
2766: --BEGIN FROM CLAUSE
2767: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');
2768: FND_DSQL.add_text('OZF_RESALE_LINES_ALL ORL, ');
2769: FND_DSQL.add_text('OZF_RESALE_BATCH_LINE_MAPS_ALL ORBMP, ');
2770: FND_DSQL.add_text('OZF_RESALE_BATCHES_ALL ORB, ');
2771: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');

Line 3367: UPDATE ozf_funds_utilized_all_b

3363: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_id = ' || p_batch_id);
3364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_threshold = ' || p_batch_threshold);
3365: END IF;
3366:
3367: UPDATE ozf_funds_utilized_all_b
3368: SET amount_remaining = 0,
3369: acctd_amount_remaining = 0,
3370: plan_curr_amount_remaining = 0,
3371: univ_curr_amount_remaining = 0,

Line 3806: FROM ozf_funds_utilized_all_b fu

3802: WHEN ((BLN.claim_amount_currency_code = l_func_currency) AND (l_func_currency <> batch_rec.currency_code)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(BLN.claim_amount_currency_code,
3803: batch_rec.currency_code,
3804: l_func_currency,
3805: (SELECT fu.exchange_rate_type
3806: FROM ozf_funds_utilized_all_b fu
3807: WHERE fu.utilization_id = BLN.utilization_id
3808: AND BLN.batch_id = batch_rec.batch_id),
3809: NULL,
3810: sysdate,

Line 3817: FROM ozf_funds_utilized_all_b fu

3813: WHEN ((BLN.claim_amount_currency_code <> l_func_currency) AND (l_func_currency <> batch_rec.currency_code)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(BLN.claim_amount_currency_code,
3814: batch_rec.currency_code,
3815: l_func_currency,
3816: (SELECT fu.exchange_rate_type
3817: FROM ozf_funds_utilized_all_b fu
3818: WHERE fu.utilization_id = BLN.utilization_id
3819: AND BLN.batch_id = batch_rec.batch_id),
3820: NULL,
3821: (SELECT fu.exchange_rate_date

Line 3822: FROM ozf_funds_utilized_all_b fu

3818: WHERE fu.utilization_id = BLN.utilization_id
3819: AND BLN.batch_id = batch_rec.batch_id),
3820: NULL,
3821: (SELECT fu.exchange_rate_date
3822: FROM ozf_funds_utilized_all_b fu
3823: WHERE fu.utilization_id = BLN.utilization_id
3824: AND BLN.batch_id = batch_rec.batch_id),
3825: BLN.CLAIM_AMOUNT)
3826: END

Line 3834: ozf_funds_utilized_all_b FU

3830: last_updated_by = fnd_global.user_id
3831: WHERE batch_id = batch_rec.batch_id
3832: AND batch_line_number IN (SELECT BLN.BATCH_LINE_NUMBER
3833: FROM ozf_sd_batch_lines_all BLN,
3834: ozf_funds_utilized_all_b FU
3835: WHERE BLN.batch_id = batch_rec.BATCH_ID
3836: AND BLN.utilization_id = FU.utilization_id
3837: AND ((batch_rec.currency_code <> BLN.claim_amount_currency_code) AND (batch_rec.currency_code <> l_func_currency))
3838: );