APPS.DPP_PURCHASEPRICE_PVT dependencies on FND_USER

Line 160: FROM fnd_user

156: --Get the user name for the last updated by user
157: BEGIN
158: SELECT user_name
159: INTO l_user_name
160: FROM fnd_user
161: WHERE user_id = l_item_price_rec.last_updated_by;
162: EXCEPTION
163: WHEN NO_DATA_FOUND THEN
164: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module,'Invalid User');

Line 181: fnd_user_resp_groups_direct furgd

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')
183: AND fpo.profile_option_id = fpov.profile_option_id
184: AND fpov.profile_option_value = TO_CHAR (l_item_price_rec.org_id)
185: AND fpov.level_id = 10004

Line 205: fnd_user_resp_groups_direct furgd,

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
207: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
208: AND fpo.profile_option_id = fpov.profile_option_id
209: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)

Line 266: fnd_user_resp_groups_direct furgd

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')
268: AND fpo.profile_option_id = fpov.profile_option_id
269: AND fpov.profile_option_value = TO_CHAR (l_item_price_rec.org_id)
270: AND fpov.level_id = 10003

Line 290: fnd_user_resp_groups_direct furgd,

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
292: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
293: AND fpo.profile_option_id = fpov.profile_option_id
294: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)

Line 351: fnd_user_resp_groups_direct furgd

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')
353: AND fpo.profile_option_id = fpov.profile_option_id
354: AND fpov.profile_option_value = TO_CHAR (l_item_price_rec.org_id)
355: AND fpov.level_id = 10002

Line 375: fnd_user_resp_groups_direct furgd,

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
377: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
378: AND fpo.profile_option_id = fpov.profile_option_id
379: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)

Line 436: fnd_user_resp_groups_direct furgd

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')
438: AND fpo.profile_option_id = fpov.profile_option_id
439: AND fpov.profile_option_value = TO_CHAR (l_item_price_rec.org_id)
440: AND fpov.level_id = 10001

Line 460: fnd_user_resp_groups_direct furgd,

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
462: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
463: AND fpo.profile_option_id = fpov.profile_option_id
464: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)