APPS.DPP_ITEMCOST_PVT dependencies on FND_USER

Line 285: FROM fnd_user

281: --Get the user name for the last updated by user
282: BEGIN
283: SELECT user_name
284: INTO l_user_name
285: FROM fnd_user
286: WHERE user_id = l_txn_hdr_rec.last_updated_by;
287: EXCEPTION
288: WHEN NO_DATA_FOUND THEN
289: DPP_UTILITY_PVT.debug_message('Invalid User');

Line 307: fnd_user_resp_groups_direct furgd

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')
309: AND fpo.profile_option_id = fpov.profile_option_id
310: AND fpov.profile_option_value = TO_CHAR (l_txn_hdr_rec.org_id)
311: AND fpov.level_id = 10004

Line 331: fnd_user_resp_groups_direct furgd,

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

Line 393: fnd_user_resp_groups_direct furgd

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')
395: AND fpo.profile_option_id = fpov.profile_option_id
396: AND fpov.profile_option_value = TO_CHAR (l_txn_hdr_rec.org_id)
397: AND fpov.level_id = 10003

Line 417: fnd_user_resp_groups_direct furgd,

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

Line 479: fnd_user_resp_groups_direct furgd

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')
481: AND fpo.profile_option_id = fpov.profile_option_id
482: AND fpov.profile_option_value = TO_CHAR (l_txn_hdr_rec.org_id)
483: AND fpov.level_id = 10002

Line 503: fnd_user_resp_groups_direct furgd,

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

Line 565: fnd_user_resp_groups_direct furgd

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')
567: AND fpo.profile_option_id = fpov.profile_option_id
568: AND fpov.profile_option_value = TO_CHAR (l_txn_hdr_rec.org_id)
569: AND fpov.level_id = 10001

Line 590: fnd_user_resp_groups_direct furgd,

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