APPS.AMS_APPROVAL_PVT dependencies on FND_PROFILE

Line 2361: l_percent := NVL(Fnd_Profile.Value('AMS_APPROVAL_CUTOFF_PERCENT'),0)/100 ;

2357: IF l_offer_type IN ('SCAN_DATA','LUMPSUM') THEN
2358: l_percent := 1;
2359: ELSE
2360: -- Why is it NVL(profile,0)/100 should it not be NVL(profile,100)/100
2361: l_percent := NVL(Fnd_Profile.Value('AMS_APPROVAL_CUTOFF_PERCENT'),0)/100 ;
2362: END IF;
2363:
2364: Get_line_amounts
2365: ( p_activity_id => p_activity_id,

Line 7239: l_auto_amount := NVL(Fnd_Profile.Value_Specific(name => 'AMS_AUTO_APPROVAL_AMOUNT',

7235: FETCH res_user_csr INTO l_user_id;
7236: CLOSE res_user_csr;
7237:
7238: -- Get the auto approval amount of the approver
7239: l_auto_amount := NVL(Fnd_Profile.Value_Specific(name => 'AMS_AUTO_APPROVAL_AMOUNT',
7240: user_id => l_user_id),0);
7241:
7242: IF l_auto_amount > 0 THEN
7243: