DBA Data[Home] [Help]

APPS.OKL_AM_BAL_WRITEOFF_PVT dependencies on FND_PROFILE

Line 845: FROM fnd_profile_options_vl

841:
842: -- get tolerance profile name
843: CURSOR get_profile_name_csr IS
844: SELECT user_profile_option_name
845: FROM fnd_profile_options_vl
846: WHERE profile_option_name = 'OKL_SMALL_BALANCE_TOLERANCE';
847:
848: k_bal_lns_rec k_bal_lns_csr%ROWTYPE;
849: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 991: FND_PROFILE.get('OKL_SMALL_BALANCE_TOLERANCE',l_tolerance_amt);

987: -- Check if total amount due is +ve else set message and exit
988: IF l_total_amount_due > 0 THEN
989:
990: --get the tolerance limit from profile
991: FND_PROFILE.get('OKL_SMALL_BALANCE_TOLERANCE',l_tolerance_amt);
992:
993: -- if no tolerance amt then assume tolerance amt = 0 ,
994: -- raise warning msg and proceed
995: -- RMUNJULU 07-APR-03 2883292 Changed IF to check for NULL instead of -1