APPS.INV_3PL_BILLING_UNITS_PVT dependencies on FND_PROFILE

Line 6: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2: /* $Header: INVVBLUB.pls 120.1.12020000.2 2012/09/25 08:54:44 gjyoti ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_3PL_BILLING_UNITS_PVT';
6: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7:
8: v_client_id mtl_billing_rule_lines_v.client_id%type;
9: v_client_code mtl_billing_rule_lines_v.client_code%type;
10: v_client_name mtl_billing_rule_lines_v.client_name%type;

Line 329: FROM fnd_profile_options

325: WHEN NO_DATA_FOUND THEN
326: BEGIN
327: SELECT creation_date
328: INTO l_profile_creation_date
329: FROM fnd_profile_options
330: WHERE profile_option_name = 'WMS_DEPLOYMENT_MODE'
331: AND application_id = 385;
332: EXCEPTION
333: WHEN OTHERS THEN