APPS.CN_USER_ACCESS_PVT dependencies on FND_PROFILE

Line 353: l_org_id := fnd_profile.value('ORG_ID');

349:
350: BEGIN
351: x_total_rows := 0;
352:
353: l_org_id := fnd_profile.value('ORG_ID');
354:
355: FOR resp_rec IN get_resp LOOP
356: IF fnd_profile.value_specific(name => 'CN_SFP_RESP_GROUP', responsibility_id => resp_rec.responsibility_id) = 'CN_SF_FINANCE_MGR' THEN
357: IF NVL(fnd_profile.value_specific(name => 'ORG_ID', responsibility_id => resp_rec.responsibility_id),-9999) = nvl(l_org_id,-9999) THEN

Line 356: IF fnd_profile.value_specific(name => 'CN_SFP_RESP_GROUP', responsibility_id => resp_rec.responsibility_id) = 'CN_SF_FINANCE_MGR' THEN

352:
353: l_org_id := fnd_profile.value('ORG_ID');
354:
355: FOR resp_rec IN get_resp LOOP
356: IF fnd_profile.value_specific(name => 'CN_SFP_RESP_GROUP', responsibility_id => resp_rec.responsibility_id) = 'CN_SF_FINANCE_MGR' THEN
357: IF NVL(fnd_profile.value_specific(name => 'ORG_ID', responsibility_id => resp_rec.responsibility_id),-9999) = nvl(l_org_id,-9999) THEN
358: l_fm_resp_key := resp_rec.responsibility_key;
359: END IF;
360: END IF;

Line 357: IF NVL(fnd_profile.value_specific(name => 'ORG_ID', responsibility_id => resp_rec.responsibility_id),-9999) = nvl(l_org_id,-9999) THEN

353: l_org_id := fnd_profile.value('ORG_ID');
354:
355: FOR resp_rec IN get_resp LOOP
356: IF fnd_profile.value_specific(name => 'CN_SFP_RESP_GROUP', responsibility_id => resp_rec.responsibility_id) = 'CN_SF_FINANCE_MGR' THEN
357: IF NVL(fnd_profile.value_specific(name => 'ORG_ID', responsibility_id => resp_rec.responsibility_id),-9999) = nvl(l_org_id,-9999) THEN
358: l_fm_resp_key := resp_rec.responsibility_key;
359: END IF;
360: END IF;
361: END LOOP;