DBA Data[Home] [Help]

APPS.OKS_WF_K_PROCESS_PVT dependencies on OKS_EXTWAR_UTIL_PVT

Line 425: to_char(OKS_EXTWAR_UTIL_PVT.round_currency_amt(estimated_amount,currency_code),

421: AND a.object1_id1 = b.party_id;
422:
423: CURSOR l_kdetails_csr(p_chr_id NUMBER) IS
424: SELECT contract_number,contract_number_modifier,
425: to_char(OKS_EXTWAR_UTIL_PVT.round_currency_amt(estimated_amount,currency_code),
426: fnd_currency.get_format_mask(currency_code, 50)
427: ) estimated_amount, currency_code
428: FROM okc_k_headers_all_b
429: WHERE id = p_chr_id;

Line 1368: to_char(OKS_EXTWAR_UTIL_PVT.round_currency_amt(okch.estimated_amount,okch.currency_code),

1364: AND a.object1_id1 = b.party_id;
1365:
1366: CURSOR l_kdetails_csr(p_chr_id NUMBER) IS
1367: SELECT okch.contract_number,okch.contract_number_modifier,
1368: to_char(OKS_EXTWAR_UTIL_PVT.round_currency_amt(okch.estimated_amount,okch.currency_code),
1369: fnd_currency.get_format_mask(okch.currency_code, 50)
1370: ) estimated_amount,okch.currency_code,hro.name,okch.short_description
1371: FROM okc_k_headers_all_v okch, hr_all_organization_units hro
1372: WHERE okch.id = p_chr_id

Line 1971: to_char(OKS_EXTWAR_UTIL_PVT.round_currency_amt(estimated_amount,currency_code),

1967: AND a.object1_id1 = b.party_id;
1968:
1969: CURSOR l_kdetails_csr(p_chr_id NUMBER) IS
1970: SELECT contract_number,contract_number_modifier,
1971: to_char(OKS_EXTWAR_UTIL_PVT.round_currency_amt(estimated_amount,currency_code),
1972: fnd_currency.get_format_mask(currency_code, 50)
1973: ) estimated_amount, currency_code
1974: FROM okc_k_headers_all_b
1975: WHERE id = p_chr_id;