DBA Data[Home] [Help]

APPS.DPP_ITEMCOST_PVT dependencies on PER_SECURITY_PROFILES

Line 332: per_security_profiles psp

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)
336: AND ((psp.view_all_organizations_flag = 'Y'

Line 418: per_security_profiles psp

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)
422: AND ((psp.view_all_organizations_flag = 'Y'

Line 504: per_security_profiles psp

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)
508: AND ((psp.view_all_organizations_flag = 'Y'

Line 591: per_security_profiles psp

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)
595: AND ((psp.view_all_organizations_flag = 'Y'