DBA Data[Home] [Help]

APPS.DPP_ITEMCOST_PVT dependencies on FND_RESPONSIBILITY_VL

Line 306: fnd_responsibility_vl frv,

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

Line 330: fnd_responsibility_vl frv,

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
333: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
334: AND fpo.profile_option_id = fpov.profile_option_id

Line 392: fnd_responsibility_vl frv,

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

Line 416: fnd_responsibility_vl frv,

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
419: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
420: AND fpo.profile_option_id = fpov.profile_option_id

Line 478: fnd_responsibility_vl frv,

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

Line 502: fnd_responsibility_vl frv,

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
505: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
506: AND fpo.profile_option_id = fpov.profile_option_id

Line 564: fnd_responsibility_vl frv,

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

Line 589: fnd_responsibility_vl frv,

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
592: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
593: AND fpo.profile_option_id = fpov.profile_option_id