DBA Data[Home] [Help]

APPS.DPP_PURCHASEPRICE_PVT dependencies on FND_PROFILE_OPTIONS

Line 178: FROM fnd_profile_options fpo,

174: --Getting a valid Price Protection Responsibility at the User Level Profile Options
175: BEGIN
176: SELECT frv.responsibility_id
177: INTO l_responsibility_id
178: FROM fnd_profile_options fpo,
179: fnd_profile_option_values fpov,
180: fnd_responsibility_vl frv,
181: fnd_user_resp_groups_direct furgd
182: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 202: FROM fnd_profile_options fpo,

198: l_responsibility_id := -1;
199: BEGIN
200: SELECT frv.responsibility_id
201: INTO l_responsibility_id
202: FROM fnd_profile_options fpo,
203: fnd_profile_option_values fpov,
204: fnd_responsibility_vl frv,
205: fnd_user_resp_groups_direct furgd,
206: per_security_profiles psp

Line 263: FROM fnd_profile_options fpo,

259: IF l_responsibility_id = -1 THEN
260: BEGIN
261: SELECT frv.responsibility_id
262: INTO l_responsibility_id
263: FROM fnd_profile_options fpo,
264: fnd_profile_option_values fpov,
265: fnd_responsibility_vl frv,
266: fnd_user_resp_groups_direct furgd
267: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 287: FROM fnd_profile_options fpo,

283: l_responsibility_id := -1;
284: BEGIN
285: SELECT frv.responsibility_id
286: INTO l_responsibility_id
287: FROM fnd_profile_options fpo,
288: fnd_profile_option_values fpov,
289: fnd_responsibility_vl frv,
290: fnd_user_resp_groups_direct furgd,
291: per_security_profiles psp

Line 348: FROM fnd_profile_options fpo,

344: IF l_responsibility_id = -1 THEN
345: BEGIN
346: SELECT frv.responsibility_id
347: INTO l_responsibility_id
348: FROM fnd_profile_options fpo,
349: fnd_profile_option_values fpov,
350: fnd_responsibility_vl frv,
351: fnd_user_resp_groups_direct furgd
352: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 372: FROM fnd_profile_options fpo,

368: l_responsibility_id := -1;
369: BEGIN
370: SELECT frv.responsibility_id
371: INTO l_responsibility_id
372: FROM fnd_profile_options fpo,
373: fnd_profile_option_values fpov,
374: fnd_responsibility_vl frv,
375: fnd_user_resp_groups_direct furgd,
376: per_security_profiles psp

Line 433: FROM fnd_profile_options fpo,

429: IF l_responsibility_id = -1 THEN
430: BEGIN
431: SELECT frv.responsibility_id
432: INTO l_responsibility_id
433: FROM fnd_profile_options fpo,
434: fnd_profile_option_values fpov,
435: fnd_responsibility_vl frv,
436: fnd_user_resp_groups_direct furgd
437: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 457: FROM fnd_profile_options fpo,

453: l_responsibility_id := -1;
454: BEGIN
455: SELECT frv.responsibility_id
456: INTO l_responsibility_id
457: FROM fnd_profile_options fpo,
458: fnd_profile_option_values fpov,
459: fnd_responsibility_vl frv,
460: fnd_user_resp_groups_direct furgd,
461: per_security_profiles psp