DBA Data[Home] [Help]

APPS.ITA_SETUP_REC_VALUES_PKG dependencies on ITA_PARAMETER_HIERARCHY

Line 749: FROM ita_parameter_hierarchy

745: l_paramcodeorg := NULL;
746:
747: SELECT parameter_code
748: INTO l_paramcodeorg
749: FROM ita_parameter_hierarchy
750: WHERE override_parameter_code = p_parameter_code
751: AND override_level = p_overridelevel;
752:
753: l_rec_value_code := getrecvaluecode0(p_context_org_id, l_paramcodeorg);

Line 776: FROM ita_parameter_hierarchy

772: l_paramcodesupps := NULL;
773:
774: SELECT override_parameter_code
775: INTO l_paramcodesupps
776: FROM ita_parameter_hierarchy
777: WHERE parameter_code =
778: (SELECT parameter_code
779: FROM ita_parameter_hierarchy
780: WHERE override_parameter_code = p_parameter_code

Line 779: FROM ita_parameter_hierarchy

775: INTO l_paramcodesupps
776: FROM ita_parameter_hierarchy
777: WHERE parameter_code =
778: (SELECT parameter_code
779: FROM ita_parameter_hierarchy
780: WHERE override_parameter_code = p_parameter_code
781: AND override_level = 2)
782: AND override_level = 1;
783: