APPS.ARH_DQM_TREE dependencies on FND_PROFILE

Line 236: l_site_status := NVL(fnd_profile.value('HZ_SHOW_ONLY_ACTIVE_ADDRESSES'),'N');

232: tmp_var1 VARCHAR2(2000);
233: --BUG#3666792
234: l_site_status VARCHAR2(10);
235: BEGIN
236: l_site_status := NVL(fnd_profile.value('HZ_SHOW_ONLY_ACTIVE_ADDRESSES'),'N');
237:
238: i := 0;
239: init_depth := p_dsprec.depth;
240: init_ndata := p_dsprec.ndata;

Line 908: l_active_site := NVL(fnd_profile.value('HZ_SHOW_ONLY_ACTIVE_ADDRESSES'),'N');

904: i := 0;
905: init_depth := p_dsprec.depth;
906: init_ndata := p_dsprec.ndata;
907:
908: l_active_site := NVL(fnd_profile.value('HZ_SHOW_ONLY_ACTIVE_ADDRESSES'),'N');
909:
910: IF p_cur_all = 'ALL' THEN
911:
912: OPEN cv FOR