DBA Data[Home] [Help]

APPS.OZF_SD_BATCH_FEED_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 959: FROM ozf_funds_utilized_all_b fu

955: WHEN ((lines.claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(lines.claim_amount_currency_code,
956: l_batch_currency,
957: l_func_currency,
958: (SELECT fu.exchange_rate_type
959: FROM ozf_funds_utilized_all_b fu
960: WHERE fu.utilization_id = lines.utilization_id
961: AND lines.batch_id = p_batch_number),
962: NULL,
963: sysdate,

Line 970: FROM ozf_funds_utilized_all_b fu

966: WHEN (lines.claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(lines.claim_amount_currency_code,
967: l_batch_currency,
968: l_func_currency,
969: (SELECT fu.exchange_rate_type
970: FROM ozf_funds_utilized_all_b fu
971: WHERE fu.utilization_id = lines.utilization_id
972: AND lines.batch_id = p_batch_number),
973: NULL,
974: (SELECT fu.exchange_rate_date

Line 975: FROM ozf_funds_utilized_all_b fu

971: WHERE fu.utilization_id = lines.utilization_id
972: AND lines.batch_id = p_batch_number),
973: NULL,
974: (SELECT fu.exchange_rate_date
975: FROM ozf_funds_utilized_all_b fu
976: WHERE fu.utilization_id = lines.utilization_id
977: AND lines.batch_id = p_batch_number),
978: lines.claim_amount)
979: END computed_batch_curr_claim_amt

Line 1411: FROM ozf_funds_utilized_all_b fu

1407: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1408: l_batch_currency,
1409: l_func_currency,
1410: (SELECT fu.exchange_rate_type
1411: FROM ozf_funds_utilized_all_b fu
1412: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1413: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1414: NULL,
1415: sysdate,

Line 1435: FROM ozf_funds_utilized_all_b fu

1431: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1432: l_batch_currency,
1433: l_func_currency,
1434: (SELECT fu.exchange_rate_type
1435: FROM ozf_funds_utilized_all_b fu
1436: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1437: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1438: NULL,
1439: (SELECT fu.exchange_rate_date

Line 1440: FROM ozf_funds_utilized_all_b fu

1436: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1437: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1438: NULL,
1439: (SELECT fu.exchange_rate_date
1440: FROM ozf_funds_utilized_all_b fu
1441: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1442: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1443: CASE
1444: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 1555: FROM ozf_funds_utilized_all_b fu

1551: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1552: l_batch_currency,
1553: l_func_currency,
1554: (SELECT fu.exchange_rate_type
1555: FROM ozf_funds_utilized_all_b fu
1556: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1557: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1558: NULL,
1559: sysdate,

Line 1580: FROM ozf_funds_utilized_all_b fu

1576: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1577: l_batch_currency,
1578: l_func_currency,
1579: (SELECT fu.exchange_rate_type
1580: FROM ozf_funds_utilized_all_b fu
1581: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1582: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1583: NULL,
1584: (SELECT fu.exchange_rate_date

Line 1585: FROM ozf_funds_utilized_all_b fu

1581: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1582: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1583: NULL,
1584: (SELECT fu.exchange_rate_date
1585: FROM ozf_funds_utilized_all_b fu
1586: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1587: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1588: claim_amount - ozf_utility_pvt.currround(CASE
1589: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 1808: FROM ozf_funds_utilized_all_b fu

1804: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1805: l_batch_currency,
1806: l_func_currency,
1807: (SELECT fu.exchange_rate_type
1808: FROM ozf_funds_utilized_all_b fu
1809: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1810: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1811: NULL,
1812: sysdate,

Line 1832: FROM ozf_funds_utilized_all_b fu

1828: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1829: l_batch_currency,
1830: l_func_currency,
1831: (SELECT fu.exchange_rate_type
1832: FROM ozf_funds_utilized_all_b fu
1833: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1834: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1835: NULL,
1836: (SELECT fu.exchange_rate_date

Line 1837: FROM ozf_funds_utilized_all_b fu

1833: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1834: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1835: NULL,
1836: (SELECT fu.exchange_rate_date
1837: FROM ozf_funds_utilized_all_b fu
1838: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1839: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1840: CASE
1841: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 1918: FROM ozf_funds_utilized_all_b fu

1914: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1915: l_batch_currency,
1916: l_func_currency,
1917: (SELECT fu.exchange_rate_type
1918: FROM ozf_funds_utilized_all_b fu
1919: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1920: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1921: NULL,
1922: sysdate,

Line 1942: FROM ozf_funds_utilized_all_b fu

1938: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1939: l_batch_currency,
1940: l_func_currency,
1941: (SELECT fu.exchange_rate_type
1942: FROM ozf_funds_utilized_all_b fu
1943: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1944: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1945: NULL,
1946: (SELECT fu.exchange_rate_date

Line 1947: FROM ozf_funds_utilized_all_b fu

1943: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1944: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1945: NULL,
1946: (SELECT fu.exchange_rate_date
1947: FROM ozf_funds_utilized_all_b fu
1948: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1949: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1950: CASE
1951: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 2059: FROM ozf_funds_utilized_all_b fu

2055: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
2056: l_batch_currency,
2057: l_func_currency,
2058: (SELECT fu.exchange_rate_type
2059: FROM ozf_funds_utilized_all_b fu
2060: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2061: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
2062: NULL,
2063: sysdate,

Line 2084: FROM ozf_funds_utilized_all_b fu

2080: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
2081: l_batch_currency,
2082: l_func_currency,
2083: (SELECT fu.exchange_rate_type
2084: FROM ozf_funds_utilized_all_b fu
2085: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2086: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
2087: NULL,
2088: (SELECT fu.exchange_rate_date

Line 2089: FROM ozf_funds_utilized_all_b fu

2085: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2086: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
2087: NULL,
2088: (SELECT fu.exchange_rate_date
2089: FROM ozf_funds_utilized_all_b fu
2090: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2091: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
2092: claim_amount - ozf_utility_pvt.currround(CASE
2093: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 2550: FROM ozf_funds_utilized_all_b fu

2546: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
2547: l_batch_currency,
2548: l_func_currency,
2549: (SELECT fu.exchange_rate_type
2550: FROM ozf_funds_utilized_all_b fu
2551: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2552: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
2553: NULL,
2554: sysdate,

Line 2574: FROM ozf_funds_utilized_all_b fu

2570: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
2571: l_batch_currency,
2572: l_func_currency,
2573: (SELECT fu.exchange_rate_type
2574: FROM ozf_funds_utilized_all_b fu
2575: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2576: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
2577: NULL,
2578: (SELECT fu.exchange_rate_date

Line 2579: FROM ozf_funds_utilized_all_b fu

2575: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2576: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
2577: NULL,
2578: (SELECT fu.exchange_rate_date
2579: FROM ozf_funds_utilized_all_b fu
2580: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2581: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
2582: CASE
2583: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 2713: FROM ozf_funds_utilized_all_b fu,

2709: THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(l_batch_line_tbl_rec.claim_amount_currency_code,
2710: l_batch_currency,
2711: l_func_currency,
2712: (SELECT fu.exchange_rate_type
2713: FROM ozf_funds_utilized_all_b fu,
2714: ozf_sd_batch_lines_all
2715: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2716: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2717: NULL,

Line 2761: FROM ozf_funds_utilized_all_b fu,

2757: THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(l_batch_line_tbl_rec.claim_amount_currency_code,
2758: l_batch_currency,
2759: l_func_currency,
2760: (SELECT fu.exchange_rate_type
2761: FROM ozf_funds_utilized_all_b fu,
2762: ozf_sd_batch_lines_all
2763: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2764: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2765: NULL,

Line 2767: FROM ozf_funds_utilized_all_b fu,

2763: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2764: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2765: NULL,
2766: (SELECT fu.exchange_rate_date
2767: FROM ozf_funds_utilized_all_b fu,
2768: ozf_sd_batch_lines_all
2769: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2770: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2771: CASE WHEN((l_batch_line_tbl_rec.approved_amount is null

Line 3056: FROM ozf_funds_utilized_all_b fu

3052: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
3053: l_batch_currency,
3054: l_func_currency,
3055: (SELECT fu.exchange_rate_type
3056: FROM ozf_funds_utilized_all_b fu
3057: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
3058: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
3059: NULL,
3060: sysdate,

Line 3080: FROM ozf_funds_utilized_all_b fu

3076: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
3077: l_batch_currency,
3078: l_func_currency,
3079: (SELECT fu.exchange_rate_type
3080: FROM ozf_funds_utilized_all_b fu
3081: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
3082: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
3083: NULL,
3084: (SELECT fu.exchange_rate_date

Line 3085: FROM ozf_funds_utilized_all_b fu

3081: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
3082: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
3083: NULL,
3084: (SELECT fu.exchange_rate_date
3085: FROM ozf_funds_utilized_all_b fu
3086: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
3087: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
3088: CASE
3089: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0