APPS.DPP_ITEMCOST_PVT dependencies on FND_USER

Line 283: FROM fnd_user

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

Line 305: fnd_user_resp_groups_direct furgd

301: INTO l_responsibility_id
302: FROM fnd_profile_options fpo,
303: fnd_profile_option_values fpov,
304: fnd_responsibility_vl frv,
305: fnd_user_resp_groups_direct furgd
306: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')
307: AND fpo.profile_option_id = fpov.profile_option_id
308: AND fpov.profile_option_value = TO_CHAR (l_txn_hdr_rec.org_id)
309: AND fpov.level_id = 10004

Line 329: fnd_user_resp_groups_direct furgd,

325: INTO l_responsibility_id
326: FROM fnd_profile_options fpo,
327: fnd_profile_option_values fpov,
328: fnd_responsibility_vl frv,
329: fnd_user_resp_groups_direct furgd,
330: per_security_profiles psp
331: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
332: AND fpo.profile_option_id = fpov.profile_option_id
333: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)

Line 391: fnd_user_resp_groups_direct furgd

387: INTO l_responsibility_id
388: FROM fnd_profile_options fpo,
389: fnd_profile_option_values fpov,
390: fnd_responsibility_vl frv,
391: fnd_user_resp_groups_direct furgd
392: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')
393: AND fpo.profile_option_id = fpov.profile_option_id
394: AND fpov.profile_option_value = TO_CHAR (l_txn_hdr_rec.org_id)
395: AND fpov.level_id = 10003

Line 415: fnd_user_resp_groups_direct furgd,

411: INTO l_responsibility_id
412: FROM fnd_profile_options fpo,
413: fnd_profile_option_values fpov,
414: fnd_responsibility_vl frv,
415: fnd_user_resp_groups_direct furgd,
416: per_security_profiles psp
417: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
418: AND fpo.profile_option_id = fpov.profile_option_id
419: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)

Line 477: fnd_user_resp_groups_direct furgd

473: INTO l_responsibility_id
474: FROM fnd_profile_options fpo,
475: fnd_profile_option_values fpov,
476: fnd_responsibility_vl frv,
477: fnd_user_resp_groups_direct furgd
478: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')
479: AND fpo.profile_option_id = fpov.profile_option_id
480: AND fpov.profile_option_value = TO_CHAR (l_txn_hdr_rec.org_id)
481: AND fpov.level_id = 10002

Line 501: fnd_user_resp_groups_direct furgd,

497: INTO l_responsibility_id
498: FROM fnd_profile_options fpo,
499: fnd_profile_option_values fpov,
500: fnd_responsibility_vl frv,
501: fnd_user_resp_groups_direct furgd,
502: per_security_profiles psp
503: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
504: AND fpo.profile_option_id = fpov.profile_option_id
505: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)

Line 563: fnd_user_resp_groups_direct furgd

559: INTO l_responsibility_id
560: FROM fnd_profile_options fpo,
561: fnd_profile_option_values fpov,
562: fnd_responsibility_vl frv,
563: fnd_user_resp_groups_direct furgd
564: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')
565: AND fpo.profile_option_id = fpov.profile_option_id
566: AND fpov.profile_option_value = TO_CHAR (l_txn_hdr_rec.org_id)
567: AND fpov.level_id = 10001

Line 588: fnd_user_resp_groups_direct furgd,

584: INTO l_responsibility_id
585: FROM fnd_profile_options fpo,
586: fnd_profile_option_values fpov,
587: fnd_responsibility_vl frv,
588: fnd_user_resp_groups_direct furgd,
589: per_security_profiles psp
590: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
591: AND fpo.profile_option_id = fpov.profile_option_id
592: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)