DBA Data[Home] [Help]

APPS.FEM_ENGINES_PKG dependencies on FEM_PB_PARAM_ASSIGNMT

Line 513: FROM fem_pb_param_assignmt

509: AND object_id = p_object_id;
510:
511: SELECT param_data_type_code, param_default_value
512: INTO v_param_data_type, v_param_default_value
513: FROM fem_pb_param_assignmt
514: WHERE parameter_name = p_parameter_name
515: AND object_type_code = p_object_type_code
516: AND step_name = p_step_name
517: AND object_id_level_flag = 'Y';

Line 545: FROM fem_pb_param_assignmt

541: AND object_id = p_object_id;
542:
543: SELECT param_data_type_code, param_default_value
544: INTO v_param_data_type, v_param_default_value
545: FROM fem_pb_param_assignmt
546: WHERE parameter_name = p_parameter_name
547: AND object_type_code = p_object_type_code
548: AND step_name = 'ALL'
549: AND object_id_level_flag = 'Y';

Line 577: FROM fem_pb_param_assignmt

573: AND object_id IS NULL;
574:
575: SELECT param_data_type_code, param_default_value
576: INTO v_param_data_type, v_param_default_value
577: FROM fem_pb_param_assignmt
578: WHERE parameter_name = p_parameter_name
579: AND object_type_code = p_object_type_code
580: AND step_name = p_step_name
581: AND object_id_level_flag = 'N';

Line 609: FROM fem_pb_param_assignmt

605: AND object_id IS NULL;
606:
607: SELECT param_data_type_code, param_default_value
608: INTO v_param_data_type, v_param_default_value
609: FROM fem_pb_param_assignmt
610: WHERE parameter_name = p_parameter_name
611: AND object_type_code = p_object_type_code
612: AND step_name = 'ALL'
613: AND object_id_level_flag = 'N';