APPS.AMW_ORG_CERT_AGGR_PKG dependencies on FND_PROFILE

Line 318: AND fv.flex_value_set_id = fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT');

314: AND es.entity_id = p_certification_id
315: AND es.level_id = 3
316: AND fv.flex_value_set_id = es.subsidiary_vs
317: AND fv.flex_value = es.subsidiary_code
318: AND fv.flex_value_set_id = fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT');
319:
320: BEGIN
321: fnd_file.put_line(fnd_file.LOG, 'begin '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
322:

Line 362: AND fv.flex_value_set_id = fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT');

358: AND es.entity_id = p_certification_id
359: AND es.level_id = 3
360: AND fv.flex_value_set_id = es.subsidiary_vs
361: AND fv.flex_value = es.subsidiary_code
362: AND fv.flex_value_set_id = fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT');
363:
364: BEGIN
365: fnd_file.put_line(fnd_file.LOG, 'begin '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
366:

Line 407: AND org_information3 = fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT');

403: INTO l_flex_value_id
404: FROM hr_organization_information
405: WHERE organization_id = p_organization_id
406: AND org_information_context = 'AMW_AUDIT_UNIT'
407: AND org_information3 = fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT');
408:
409: recurse_aggregate(p_certification_id, l_flex_value_id);
410:
411: