DBA Data[Home] [Help]

APPS.DPP_ITEMCOST_PVT dependencies on FND_PROFILE_OPTIONS

Line 304: FROM fnd_profile_options fpo,

300: --Getting a valid Price Protection Responsibility at the User Level Profile Options
301: BEGIN
302: SELECT frv.responsibility_id
303: INTO l_responsibility_id
304: FROM fnd_profile_options fpo,
305: fnd_profile_option_values fpov,
306: fnd_responsibility_vl frv,
307: fnd_user_resp_groups_direct furgd
308: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 328: FROM fnd_profile_options fpo,

324: l_responsibility_id := -1;
325: BEGIN
326: SELECT frv.responsibility_id
327: INTO l_responsibility_id
328: FROM fnd_profile_options fpo,
329: fnd_profile_option_values fpov,
330: fnd_responsibility_vl frv,
331: fnd_user_resp_groups_direct furgd,
332: per_security_profiles psp

Line 390: FROM fnd_profile_options fpo,

386: IF l_responsibility_id = -1 THEN
387: BEGIN
388: SELECT frv.responsibility_id
389: INTO l_responsibility_id
390: FROM fnd_profile_options fpo,
391: fnd_profile_option_values fpov,
392: fnd_responsibility_vl frv,
393: fnd_user_resp_groups_direct furgd
394: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 414: FROM fnd_profile_options fpo,

410: l_responsibility_id := -1;
411: BEGIN
412: SELECT frv.responsibility_id
413: INTO l_responsibility_id
414: FROM fnd_profile_options fpo,
415: fnd_profile_option_values fpov,
416: fnd_responsibility_vl frv,
417: fnd_user_resp_groups_direct furgd,
418: per_security_profiles psp

Line 476: FROM fnd_profile_options fpo,

472: IF l_responsibility_id = -1 THEN
473: BEGIN
474: SELECT frv.responsibility_id
475: INTO l_responsibility_id
476: FROM fnd_profile_options fpo,
477: fnd_profile_option_values fpov,
478: fnd_responsibility_vl frv,
479: fnd_user_resp_groups_direct furgd
480: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 500: FROM fnd_profile_options fpo,

496: l_responsibility_id := -1;
497: BEGIN
498: SELECT frv.responsibility_id
499: INTO l_responsibility_id
500: FROM fnd_profile_options fpo,
501: fnd_profile_option_values fpov,
502: fnd_responsibility_vl frv,
503: fnd_user_resp_groups_direct furgd,
504: per_security_profiles psp

Line 562: FROM fnd_profile_options fpo,

558: IF l_responsibility_id = -1 THEN
559: BEGIN
560: SELECT frv.responsibility_id
561: INTO l_responsibility_id
562: FROM fnd_profile_options fpo,
563: fnd_profile_option_values fpov,
564: fnd_responsibility_vl frv,
565: fnd_user_resp_groups_direct furgd
566: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 587: FROM fnd_profile_options fpo,

583: BEGIN
584:
585: SELECT frv.responsibility_id
586: INTO l_responsibility_id
587: FROM fnd_profile_options fpo,
588: fnd_profile_option_values fpov,
589: fnd_responsibility_vl frv,
590: fnd_user_resp_groups_direct furgd,
591: per_security_profiles psp